Google Sheets
How do I change the detected column type?
How does Relay.app infer column types in Google Sheets?
As Google Sheets doesn't have native types for columns, Relay.app infers the data type for each column based on the values in the first row (below the headers) of that column.
If the there is no row below the header row, Relay.app will assume a type based on the name of the header.

The depicted above is infered as follows in Relay.app:

Updating infered column types
To update the infered column types, add (or change) a/the value in the first row, and click the 'refresh' icon or 'Refresh data' from the overflow menu of a Step. After the column type has been re-inferred, you can remove data from the first row again if you just added it to force-infer the correct column type.

Why didn't my "New row added" trigger pick up on a new row?
For Relay.app to detect a row as new, the row has to have previously been empty, then set to some value(s).
If all of the data in a row is completely replaced, Relay.app won't be able to detect that the row is new, even if all of its cells have been updated.
Why can't I find my Google Sheet?
If the Google Sheet you need isn't coming up in search, try a few things:
Confirm you're connected to the right Google account: The account listed in the
Run as
menu should match the account with access to the file.If it's a shared file, try moving or adding the file to
My Drive
: Google's API often omits files that are only under theShared with me
folder. Open the sheet in Drive, selectAdd shortcut to Drive
under theFile
menu or move it to a folder in your Drive, and refresh the picker in Relay.app.Try pasting the spreadsheet URL directly into the file picker: Relay.app will try to fetch the sheet by URL, even if the name wasn't appearing in the list.
Reauthorize access to your Google account: Go to your
Apps
page and reconnect the Google Sheets app to force Google to refresh permissions.
Last updated
Was this helpful?