Scheduled X Google Spreedsheet x Quickbooks Online create item

  • 23 January 2021
  • 1 reply

Userlevel 1

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

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

Userlevel 7
Badge +11

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 :)