Skip to main content
Best answer

"Create Google Sheets Spreadsheet Row if it doesn’t exist yet?" missing?

  • February 20, 2023
  • 2 replies
  • 538 views

kjems

Hi there.

I have found other post on how to update a google sheet row, if value in column exist OR create row, if value not exist. 

But when i choose action “Lookup Spreadsheet Rows (output as Line Items)", i cant find the option “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?”

Was it somehow removed, or am i just not looking in the right place?

 

 

Best answer by SamBBest answer by SamB

Hi there, @kjems

Ah, the option to create a new row if one isn’t found is only available on the Lookup Spreadsheet Row action, not the Lookup Spreadsheet Rows (output as Line Items) action. So you’d need to select the other Lookup Spreadsheet Row action instead: 
35aefbb7d71908ec85c8263bedc18fa1.png
Then you should see a “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” option available to select when setting it up:
3a2af985e1c81554d7dc0412d81baaf8.png
When selected, you’ll then be able to fill out the different fields to populate the row with the relevant information. 

Hope that helps! 🙂

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7597 replies
  • Answer
  • February 20, 2023

Hi there, @kjems

Ah, the option to create a new row if one isn’t found is only available on the Lookup Spreadsheet Row action, not the Lookup Spreadsheet Rows (output as Line Items) action. So you’d need to select the other Lookup Spreadsheet Row action instead: 
35aefbb7d71908ec85c8263bedc18fa1.png
Then you should see a “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” option available to select when setting it up:
3a2af985e1c81554d7dc0412d81baaf8.png
When selected, you’ll then be able to fill out the different fields to populate the row with the relevant information. 

Hope that helps! 🙂


kjems
  • Author
  • Beginner
  • 1 reply
  • March 27, 2023

Yes, i figured it out. Thanks!