Google Sheets

To use Google Sheets as a Data Source, you must first connect your Google Drive account with Afterpattern. This is easy. Just go to Account Settings > Integrations and click 'sign in with Google':

Pulling data from Google Sheets operates almost exactly like pulling data from a Workbase, except that with Google Sheets you must specify exactly what data you want to pull in.

After you add Google Sheets as a Data Source, click "edit" to specify what data you want to pull in:

When editing your Google Sheets Data Source, each row is a single piece of data pulled from Google Sheets. For each piece of data, you must specific: (1) the label you want this data to have in your App; and (2) the Google Sheet column this piece of data corresponds to:

You get to decide what the key column should be. Remember, the key column must include unique values for each row. The key column is also what the end-user is likely to use when "looking up" a specific row within your Google Sheet table.

How do you want your App to "look up" a row of data within your Google Sheets table?

After you set up your Google Sheets Data Source, you need to provide a mechanism in your App for the end-user to "look up" a specific row within your Google Sheets table. There are four methods for "looking up" a row of data within a Data Source, all are outlined here.

This video reviews one of the most common methods for "looking up" a row of data, the Data Source Selector question:

‍

This works exactly the same as sending data to a Workbase.