About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • Troubleshooting
  • Need help setting up a Zap that automatically fetches my Shopify orders and creates rows in Google Sheets daily.
Question

Need help setting up a Zap that automatically fetches my Shopify orders and creates rows in Google Sheets daily.

  • 13 April 2023
  • 1 reply
  • 64 views
AhmedAbid

I basically want for Zapier to go to shopify every day and get all the new orders in the last 24 hours and paste them in google sheet below the old orders. I am currently stuck after making the schedule and filter 

Now stuck here how to get orders from shopify to google sheets

 

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

Brem
Userlevel 4
Badge +6

Hi @AhmedAbid 

Welcome to the Community! I'm sorry you’re having trouble with your Zap.

At the moment, Zaps are only built to look at new and incoming information, and won't process existing data. You can read a bit more about this here: https://zapier.com/help/create/basics/why-isnt-my-zap-triggering-on-existing-records. This means that data created before the Zap is turned on won't be pulled in automatically.

In order to get existing data into your action app, there are two options: Transfer by Zapier and a Google Sheets Workaround.

Transfer by Zapier:
Transfer is a feature that you can use to send existing data from one app to another. Transfer lets you select which data to send so you only send the data that you want: https://zapier.com/help/create/other-functions/bulk-import-data-into-apps-with-transfer.

Transfer currently works with the following source apps: https://zapier.com/help/create/other-functions/which-apps-does-transfer-support.

Google Sheets:
Alternatively, if you're able to export data from your trigger app as a spreadsheet or CSV file, you may be able to "import" them using a separate Zap. This guide has some great visual references for getting that workaround set up:
https://community.zapier.com/tips-and-inspiration-5/use-google-sheets-to-import-existing-data-from-your-apps-12143?postid=51061#post51061

For more information on using Transfer or Google Sheets, search our Help Center.

Terms & Conditions