Is there a way to automatically copy filtered content from sheet A to sheet B daily?

Tiantian Zhang

I have a sheet (sheet A) that is my source sheet, and the content is updated frequently.

I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared.

I tried to use the "Automation" -> Create Workflow -> Copy Rows, however, I don't know how to clear the content in sheet B before each day's copy, right now the sheet B is keeping growing every day...

Thanks for the help in advance!

Andrée Starå

Hi Tiantian,

The third-party service, Zapier, could be an excellent option for this scenario. (Untested) Is that an option for you?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD