Skip to main content
Question

How to export and kverwrite Printavo orders data to Google Sheets every 4 hours?

  • 3 September 2024
  • 2 replies
  • 15 views

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.

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Troy Tessalone
Forum|alt.badge.img+14

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.

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • September 19, 2024

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! 🙂