Reading rows from Google Sheets
To get data from rows in Google Sheets, you first need to select the Google Sheet you want to read rows from.
Before you can map the data from your Google Sheet, though, you would need to follow 2 simple steps below.
- Fill out the necessary columns that you require (i.e. Date, Name, Account, etc) in the first row
- Enter some sample/dummy data in the second row beneath the first (NOTE: Without this row of dummy data, the recipe will not be able to pick up the column names.)
In fact, we have a sample sheet here for you to help you quickly understand the steps: http://bit.ly/1GMsDV9
The resultant datatree from your trigger that will appear in your actions is as shown below. If you do not get your columns, or if your columns do not accurately reflect the latest version of your Google Sheet, simply select "Refresh schema and save" (the alternative dropdown option to the "Save" option) the recipe, and the latest columns should show up:
- The recipe treats all unprocessed rows as 'new' rows. The state of each row (processed or unprocessed) is remembered only by the recipe which has processed the rows. For example, if you make a copy of the recipe which has already processed all the rows within the Google Sheet, the copied recipe will then treat all rows as 'new' rows again
- There should not be any empty rows within the data you wish to read. The recipe will stop at the first blank row as it will treat the blank row as the end of the spreadsheet.
Any updates to processed rows will not be picked up by the recipe again. To update a row, you should use update row action. To learn more about update row action, you can check out this article on how it works.