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.

Relay.app infers data types for the columns based on the values in the first row

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

To force-refresh the column types as inferred by Relay.app, click the little 'refresh' icon

Updating inferred column types

To update the inferred 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.

Generic way to refresh columns/data: click 'Refresh data' in the overflow menu of a Step

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:

1. 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.

2. 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 the Shared with me folder. Open the sheet in Drive, select Add shortcut to Drive under the File menu or move it to a folder in your Drive, and refresh the picker in Relay.app.

3. 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.

4. Reauthorize access to your Google account: Go to your Apps page and reconnect the Google Sheets app to force Google to refresh permissions.

Why am I getting an error about missing headers in my sheet?

In order for Relay.app to be able to correctly parse the information in your spreadsheet, it needs to have a header row. The header row must be in Row 1 of your sheet.

If you are using Google Sheets Tables, make sure that the table headers are in Row 1. (Tip: If the headers are in Row 2, you can delete the tabbed Row 1 to move the table up.)

Handling hidden rows in Google Sheets

If you are adding rows to a Google Sheet with hidden rows, note that "Add row to sheet" adds rows after the last visible row. If your hidden rows are at the bottom of your sheet (if you are adding rows to the bottom), they can get overridden by the newly added row.

To avoid this, make sure that you have a visible row at the bottom of your sheet (or at the top, if you are adding new rows to the top).