• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home App Resources Google Sheets

Google Sheets: How to make sure that my recipe doesn't trigger on an uncompleted row

Modified on: Wed, Nov 16, 2016 at 1:26 PM

If you set your Google Sheets as a trigger, you may encounter a situation where the recipe picks up the row before you are done populating all the columns. To prevent incomplete data from being used for for population, you may want to set up your recipe like this one. 


blob1477984955800.png

The example recipe is triggered when a new row is added to google sheets.  

Step 1 is a conditional action, set up such that if the last column is "not present", or does not contain any data, the recipe will wait (Step 2) for a set amount of time (you can use a 5 minute wait). This amount of time should depend on how much time is expected to complete each row by manual entry.


Step 3 will then run a search in the same sheet from the trigger, using the first column's data. This action will allow you to go back and use the completed data instead of the trigger data. As such, all following steps that require pills from the row should be acquired from this step, and not from the trigger output. Do note that this step will only work for a search query with the data being a unique identifier. If the search returns multiple results, the search may not return the row you actually want processed. 


This is how it should look:

blob1477985300675.png

Once these 3 steps are set up, you can add additional steps that require the data from these columns for mapping to other applications!


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