Hello,
I am trying to set up a zap that reads an application “Printavo” when an order is set to “completed” and then finds a google sheet named the same ID as the printavo invoice and takes certain cells data from that sheet and records them into another sheet in the row that corresponds with the Printavo invoice ID.
Is this possible?
Thank you,
Kyle
Hi
Check out this related topic:
NOTE: You may want to consider using 1 Airtable Base instead of multiple GSheets.
Hi
At a high level, yes that should be possible.
Trigger: Updated Quote/Invoice in Printavo
Action: Find a file in Google Drive (find the file with the invoice id)
Action: Find Spreadsheet Row(s) (possible need for multiple of these or possibly the find spreadsheet rows action… it is not very clear if the data will be on 1 row or many rows but this would be to retrieve data from the spreadsheet found in step 2)
Action: Find Spreadsheet Row (find the row with the invoice number on the 2nd sheet)
Action: Update Spreadsheet Row.
The above plus what Troy shared should get you headed in the right direction!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.