Skip to main content
Question

Blank excel spreadsheet in the zap.

  • March 6, 2023
  • 7 replies
  • 125 views

developer_automation

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 6, 2023

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.

 


developer_automation

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 7, 2023

@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.


developer_automation

@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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 9, 2023

@developer_automation 

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


developer_automation

@Troy Tessalone 

Is there any other way to accomplish this ?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 9, 2023

@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.