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.

  • Home
  • Get Help
  • How Do I
  • How to extract data from new Google Sheets and add rows to a master sheet, then delete daily sheet?

I need help with the following Zap:

  1. Gmail excel attachment is uploaded to Google sheets (WORKS)
  2. How do I extract the google sheet data (It is sent daily)?
  3. How do i create new rows to the master sheet from the new google sheet sent daily?
  4. Delete the daily google sheet once the master sheet is updated?

 

Hi there @tothehaiway,

Welcome to the Community! 🎉

You can use Formatter by Zapier - Import CSV function to extract the Google Sheets data from the email attachment and followed by the “Create Spreadsheet Row” action to create new rows to the master sheet.

Additionally, there isn’t a way to delete a whole spreadsheet at the moment.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

 

The daily sheet’s first 3 rows are not the header row… the way the CRM sends the excel sheet it shows. 
 

 

Do we have to delete the first 3 rows?

or can zapier read the 4th row?

Hi @tothehaiway 👋

Do we have to delete the first 3 rows?

or can zapier read the 4th row?

In order for Formatter to be able to read the CSV file correctly you’d likely need to delete the first 3 rows. There’s a Clear Spreadsheet Row action available for Google Sheets that would clear the data from those rows but it wouldn’t delete them. Is there any way you can adjust the export from the CRM to have the header added at row 1?

Looking forward to hearing from you!

Terms & Conditions