• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
Solution home App Resources Google Sheets

Google Sheets: Reading/Processing rows from Google Sheets

Created by: Huilin Yang

Modified on: Wed, Oct 12, 2016 at 1:06 AM

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.

  1. Fill out the necessary columns that you require (i.e. Date, Name, Account, etc) in the first row
  2. 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:



Additional notes:

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



H
Huilin is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2020   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato