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: Then you should see a “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” option available to select when setting it up: When selected, you’ll then be able to fill out the different fields to populate the row with the relevant information.
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: Then you should see a “Create Google Sheets Spreadsheet Row if it doesn’t exist yet?” option available to select when setting it up: When selected, you’ll then be able to fill out the different fields to populate the row with the relevant information.