![]() It’s not too expensive to have an account and has allowed a novice like me to easily build automated reporting into google sheets You can set up multiple email address with zapier’s parser service. The query + importrange used in this way makes it so you only have to allow access once instead of every time I’ve set up 5 or 6 tabs this way all to the same sheet and from that data pond sheet I use another query(importrange to get whatever data i need from that to where it needs to go. xlsx file > uploads that file to Replace a file every time it gets a new email > then using a query + importrange to pull that whole sheet over to a Data Source Sheet (my little data pond). I use a WMS and have set automated reports to be emailed to Zapier’s Email Parser service which scrapes the. Can you get these CSV reports to get emailed out automatically on a cron schedule of some sort?
0 Comments
Leave a Reply. |