Skip to main content
Question

Scheduled X Google Spreedsheet x Quickbooks Online create item

  • January 23, 2021
  • 1 reply
  • 36 views

Hi Expert, 

it is amazing to have Zapier automation, but it just think of my case but don’t know how to handling the flow, so i would like to seek your idea on it

My flow:

  1. scheduled to update every 12 hours, twice a day
  2. i have a google spreadsheet which store up the product information, including name, sku, price, etc. let say i have 100 row existing now
  3. when time arrival, i would like to compare the existing spreadsheet VS last spreadsheet 12 hours before.
  4. So if i have 15 rows added during previous 12 hours
  5. then i will use line itemizer to store up the data.
  6. Finally create the new item in quickbooks online.

i am very new to zapier, i believe i can do it but it seems that it is too difficult for me even i dont know the right sequence and logic, can you please give me some idea on handling the flow, thanks!!
 

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.

1 reply

nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • February 2, 2021

Hi @louis kwok!

It looks like you’ve gotten a bit farther, based on this post. If you still need help, please let us know. But it seems like that other thread is the better place to respond :)