Skip to main content
  • Home
  • Get Help
  • How Do I
  • How to export and kverwrite Printavo orders data to Google Sheets every 4 hours?

I would like to setup a zap that will take the Printavo Orders Data and export it to the same google sheet overwriting all previous data.   5 times a day every 4 hours would be perfect.

 

The intent is to capture all changes to the system.  Often times an old order will get paid changing the Paid column data from FALSE to TRUE as one example.  Or the sales rep on record could get changed.  Order Status could get changed.  Etc etc.  

 

What i have been able to accomplish is creating a new record when a quote / invoice (their phrasing for order) is created to my spreadsheet but on changes to an order, its creating a duplicate record rather than editing the row in question.

Hi @Headlines 

Steps

  1. Trigger: Printavo - Updated Quote/Invoice
    1. NOTE: You probably need a separate Zap for Printavo - New Quote/Invoice
  2. Action: GSheets - Lookup Row
    1. Enable create row if not found
  3. Action: Filter
    1. Check if row was found in step 2
  4. Action: GSheets - Update Row
    1. Map the Row ID from Step 2

 

If you want to run on a schedule, then that will involve using the Printavo API and the GSheet API, which are advanced approaches.

 

Hi there, @Headlines 👋

Just came across your post and wondered how things are going on this. Did you manage to get the desired workflow set up as per Troy’s suggestions?

Keen to ensure you’re all set so let us know if you need any further assistance at all - always happy to lend a hand! 🙂

Terms & Conditions