Skip to main content
Question

Update GSheet with Printavato Invoice # and ID from diff GSheet

  • 22 February 2022
  • 2 replies
  • 19 views

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   

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

Troy Tessalone
Userlevel 7
Badge +14

Hi @Mckcheesy 

Check out this related topic:

 

NOTE: You may want to consider using 1 Airtable Base instead of multiple GSheets.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
GetUWired
Userlevel 7
Badge +12

Hi @Mckcheesy 

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! 

Terms & Conditions