Hi everyone,
I’m looking for a solution when my trigger will pullup the information from the last row in particular column and send it to Slack.
Where I’m stuck at is the Lookup value as it needs to be filled out. I’m not looking for any particular Value to find, but the last one.
Can you help me what to fill out in the Lookup Value column in this situation?
Hi
You’d need for all your rows to have a Lookup field.
For example, you could have a field called Lookup, with values of Yes/No.
All unused rows would have the value of Yes, then after the row has been looked up, you can use a Zap step to update the row to change the value to No.
Also make sure this field is set as such:
Alternative is to use Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations
Airtable has Views.
Views can be sorted. (e.g. new to old)
Views can have filters. (e.g. Status = X)
Then in an Airtable Find Record step you can use the Search Formula to return the top 1 record.
Again, you’d need to use a Zap step to update the record after it’s been used, so it moves out of the View.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.