Skip to main content

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. 

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.

 


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. 


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


@developer_automation 

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


@Troy Tessalone 

Is there any other way to accomplish this ?


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