Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Question

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

  • April 13, 2023
  • 1 reply
  • 194 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
Forum|alt.badge.img+6
  • BremZapier Staff
  • Zapier Staff
  • April 13, 2023

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 & ConditionsAccessibility statement