Hi Guys, I would like to generate daily rep...

(Dan) #1

Hi Guys,

I would like to generate daily report and save it on G Drive.

Is there a workflow to save reports in a particular file location in G Drive instead of emailing to users?

Please help.

Thanks.

Daniel.

(Challa Ramakrishna) #2

I think it’s better to use Google Appscript. Appscript is more reliable in this case. But for that you should have all that data in your sheets. For virtual columns what you used in the sheet to be queried again in a sheet.

(Aleksi Alkio) #3

You have an option to archive the pdf into the gDrive. Have you tested that feature?

(Dan) #4

@Aleksi_Alkio no sorry. Do you mean archive from the app feature? Could you give me a hint pls?

(Dan) #5

@Challa_Ramakrishna thanks for your response.

(Aleksi Alkio) #6

When you create a workflow or report, you have that option. You can find it from the bottom of workflow definition.

(Philip Garrett) #7

@Daniel_Veluswamy

As Aleksi said see topic “Attachment Archive” in this article help.appsheet.com - Sending Email from a Workflow Rule or Scheduled Report

Sending Email from a Workflow Rule or Scheduled Report help.appsheet.com

(Dan) #8

@Aleksi_Alkio @Philip_Garrett_Appsh Thanks Guys. Much appreciate your help. Grateful.