About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Blank excel spreadsheet in the zap.

  • 6 March 2023
  • 7 replies
  • 101 views
developer_automation
Userlevel 1

I am setting up a zap that required the removal of all data added in spreadsheet at every 24 hours interval.

Is there any way to blank excel spreadsheet or delete all the rows of the spreadsheet in zapier. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @developer_automation 

Good question.

You may want to think about a different approach.

Perhaps try making a copy of a file, then replacing a file, if you need to use the same file in GDrive.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
developer_automation
Userlevel 1

Hi @Troy Tessalone ,

Thank you for the response.

I only required to blank out the excel spreadsheet. 

How do I make an Excel spreadsheet blank using the zapier? Zapier didn’t have any action event available for this. 

Troy Tessalone
Userlevel 7
Badge +14

@developer_automation 

Please clarify if you are trying to use GSheet or Excel.

If GSheet, then you can try the actions above to copy a blank GSheet and replace the GSheet using GDrive.

If Excel, then OneDrive does not have the same Zap app capabilities.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
developer_automation
Userlevel 1

@Troy Tessalone , As per the requirement I only required to use Excel not the GSheet. 

I need to empty the Excel sheet everyday at midnight 12:00

Any assistance would be greatly appreciated.

Thanks

Troy Tessalone
Userlevel 7
Badge +14

@developer_automation 

If Excel, then OneDrive does not have the same Zap app capabilities.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
developer_automation
Userlevel 1

@Troy Tessalone 

Is there any other way to accomplish this ?

Troy Tessalone
Userlevel 7
Badge +14

@developer_automation 

I don’t know of a good way to do so with Zaps that won’t be outrageously Task intensive and likely not worth it.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions