Templates / Check for new data in Google Sheets

Create a new spreadsheet and edit with others at the same time - from your computer, phone or tablet (updated: 1657714838988)

Check for new data in Google Sheets

Intermediate
Google SheetsUniversal

Overview

Fetching new rows in Google Sheets and sending them somewhere else is a very common requirement due to the infinite potential uses of Google Sheets.

This template allows your team to easily check for new rows in a google sheet and perform some action when new rows are found, such as:

  • Sending them to a CRM

  • Sending a notification to Slack

  • Sending to the 100s of other connectors available in the Tray platform.

This Workflow closely imitates a trigger and runs every 5 minutes to pick up any new rows that have been added to a Google Sheet.

Connectors Used

The following connectors are used in this template. This is mostly provided for reference only - there is no need to read through the linked connector pages. All you need to know for this template is explained here, although you will likely need to look up service authentication instructions:

End Result

Any time new rows are added to a Google Sheet:

google-sheet-new-row-added

This workflow will create a data object for each row:

google-sheet-data-object-example-v2

Which can then be sent to any service of your choice.

For example it could be sent to a Slack Channel:

google-sheet-new-row-sent-to-slack-channel

Or it could be sent to a CRM such as Salesforce:

google-sheet-new-row-sent-to-salesforce

This workflow only creates the new row objects, it leaves you to decide what service to send them to, as per the Getting Live section below

Prerequisites

This workflow assumes the following:

  • Your team can authenticate to Google Sheets

  • Your Google Sheet has column Headers as the first row

  • New rows will be added to the bottom of this Sheet

  • Rows in this spreadsheet will not ever be deleted

Getting Live

To configure the workflow for your own use:

Workflow logic

check-for-new-rows-in-google-sheets-complete-workflow

Step-by-step explanation

Note that in step 2, the last_row_processed name given to the key is arbitrary and could be anything such as 'last_row' or 'last_processed_row'. You just need to make sure that other data storage steps (i.e. Set Last Row Processed (storage-2) use the same key name