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.

Hi Everyone!

 

I would like to ask for your help in creating the following Zap. We are building a paid media digital dashboard, the output is Google Data Studio and the final destination of all raw data is Google Bigquery.

One of the paid media system is a bit far behind and our only possibility is to send a scheduled report to an email address.

CSV attachments arrives to Gmail on a daily basis (different CSVs for different campaigns) → we should send it with Zapier to Google Sheet, but first we should always delete the first 9 raws from the attachments. From Google Sheets we can pull this data to Bigquery.

It would be also nice to always delete the data from the day before automatically. And it is also important to be able to pull each CSVs to one Google Sheet (all of the without the first 9 raws)

Has anybody tried something like this before?

Thank you in advance!

Bendi

Hi @nagybendi ,

Thanks for reaching out!

I see Nikki in Support was able to help you with this workflow! In an effort to assist other users who may be interested in a similar flow, I am posting a summary of their response below.

If you have any more questions, just let us know!

 

Step 1: Trigger - Gmail: New Email Matching Search (to trigger off the data emails that you are receiving)
Step 2: Action - Formatter > Utilities > Import CSV
Step 3: Action - Google Sheets: Create Many Row(s)

What this Zap would do is trigger every time you get the email that has the data, and then create rows in a Google Sheet with the data that comes in.

As for overwriting data, Zapier is not a tool for deleting existing data...we exist to create new data.

As for your campaigns, I would tend to recommend doing a report per campaign, as it sounds like that would make your CSV files smaller and more manageable within Zapier.

Terms & Conditions