Workflow Generate PDF on Add if row is added directly in Google Sheets

Hi,
I am trying to automatically create PDF invoices when someone purchases a product.

I have a Google Sheet with a transaction table and I created a workflow to save a PDF in Google Drive when I add a new row via AppSheet.
But is it possible to generate the PDF when a new row is added in the Google Sheet directly and not via AppSheet?
I want to connect my online shop via Zapier with Google Sheets to add these transactions to the table automatically but when it does that, AppSheet doesn’t create a PDF. It only works when I add a new row via AppSheet.

Thanks so much in advance for your help!

I’m afraid it won’t trigger it. Scheduled report would work because it’s triggered from server. Though it will trigger that PDF like once a day or few times per day.

1 Like

Thanks for your fast response!
Is there a possibility to create a report only for rows that have been added after the last report?
Or maybe is there an option to send Zapier data to AppSheet so that the trigger is activated?

Yes, you can filter for example with the date value. Today it will generate today’s records.

Your Zap could invoke the AppSheet API to add the record to the table.
(Your Zap would do this in lieu of adding the record to the Google sheet directly.)

Adds, Updates, and Deletes performed through the AppSheet API invoke the workflow rules.

1 Like

Though you would need to have Business plan for the Appsheet API.

Thank you @Aleksi and @Phil for your responses!
Is there an option to generate a PDF as a behaviour? So that I can manually create invoices from the AppSheet app? For example by triggering the workflow through pushing a button in the app?

Please check this article and maybe the other one as well…

2 Likes

To add to Aleksi’s excellent response.

Regarding “So that I can manually create invoices from the AppSheet app? For example by triggering the workflow through pushing a button in the app?”

See topic " Sending Email from an Action Button" in this article https://help.appsheet.com/en/articles/961707-workflow

2 Likes

Thank you for all your answers and your help!