How can I automatically update my website data in Excel?

abdmahyni
Shopify Partner
1 0 0

Hello Guys 

i want to make an excel file for all my website data like 
clients 
selling 
inventory 
etc.... 

so i want to make an excel to be updated automatically based on what we do or what happen on website , what will be the way ? prefer free if available  

thanks 

Reply 1 (1)

PaulNewton
Shopify Partner
6339 580 1350

For "free" to match all requirements see the api docs to spend time making your own ETL process for the shopify side of the part are here:

https://shopify.dev/docs/apps 

For the excel part of the process research microsofts docs.

 

For products data , for free,  data see shopify-flow's various triggers and the google sheets row connector then figure out a way to connect it to excel.

https://help.shopify.com/en/manual/shopify-flow/reference/triggers 

https://help.shopify.com/en/manual/shopify-flow/reference/connectors

 

For serious business just use an app or existing service, these app make you time in money.

Otherwise if the spreadsheet have no value why spend time on automating them.

 

See services like zapier, make.com, retool, etc

See apps like matrixify,ez-exporter for setting up simple fast CSV spreadsheet based workflows.

 

For serious needs to automate data exports needing additional business logic or to fill in the gaps other ETL apps cannot handle see scriptable automation apps like mechanic to use email, FTP, webhooks, or http apis integrations.

https://tasks.mechanic.dev/?tags=CSV 

 

 

If you need this type of automation explored then contact me by my email for services.
Contact info in forum signature.
ALWAYS please provide context, examples: store url, theme name, post url(s) , or any further detail in ALL correspondence.

 

 

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org