skip to Main Content

Google Sheets

  1. Home
  2. Knowledge Base
  3. Special Actions
  4. Google Sheets

This integration requires Uncanny Automator Pro or a free Automator account with available credits.

Connect a Google Account

To get started with Google Sheets, connect Automator to your Google account:

  1. Visit Automator > Settings in /wp-admin/ on  your website.
  2. In the Google tab, click Connect an account.
  3. In the list of required permissions, make sure everything is checked off.
  4. Click Allow to let Automator access your Google Drive files and spreadsheets.

Once this is done, a success message will be displayed on your website and the Google Sheets actions will be available. Once set up, Automator can be used to add new records to a Google Sheet and/or update existing records.

Create a row in a Google Sheet

To configure the Create a row action in Google sheets:

  1. Choose the Google Sheets integration in the Actions list.Google Sheets Integration
  2. Choose the Create a row in a Google Sheet action.
  3. Make selections for the DriveSpreadsheet and Worksheet for your account. These values determine where the rows will be added and what columns will be available.
  4. After clicking the Get columns button, you will see a list of columns for your worksheet on the left and a list of values on the right.
  5. For each row, populate the Value that you want to add. In most cases, you will want to choose tokens from the triggers or the system by choosing the * icon to the right of the field. (You cannot add or remove columns from the Google Sheet, you can only add rows for the existing columns. If you add or remove columns in Google Sheets itself, make sure you click Get Columns again.)
  6. Save your updates and make sure the triggers, actions and recipe are all live.

Connect Automator to Google Sheets

Update a row in a Google Sheet

  1. Choose the Google Sheets integration in the Actions list.Google Sheets Integration
  2. Choose the Update a row in a Google Sheet action.
  3. Make selections for the DriveSpreadsheet and Worksheet for your account.Update a row in a Google Sheet
  4. After clicking the Get columns button, you will see a list of columns for your worksheet on the left and a list of values on the right.
  5. In the Column search field, choose the column that you will use to identify the row to update. This correlates with the value you enter in the Match value field, which can be a token. This action works by finding a matching value in a column you specify, then updating the values in that row. In other words, suppose that column A in the worksheet has a list of row titles, and the row we want to update has a value of “Uncanny Automator” in the “Title” column. We would then make the Column search column “Title” and the value we want to match is “Uncanny Automator”. The action will find that row and be able to update other cells in that row.
  6. In the Row table, review the list of columns and click the Update? switch for rows you want to update. You can update 1 or all columns, including the search column, it’s up to you. By default, no columns will be updated.
  7. For every column where Update? is checked, enter a new value in the Value column. This will be the new cell value in the Google Sheet.

Notes

  • You can change your connected Google account from the Automator Settings page, but you can only have one connected account at a time. Be very careful changing the account; it may break existing recipes.
  • If you decide to change your permissions or want to review what Uncanny Automator is allowed to do, please refer to this Google Support article: https://support.google.com/accounts/answer/3466521?hl=en
  • All connections are limited to no more than 300 writes per minute. This is controlled by Google and will be increased soon, but for very high-traffic sites passing a lot of data to Google Sheets this is an important consideration.
Back To Top