Connect an orders sheet in Google Sheets to a Google Docs template
What is the problem & what have you tried?
The workflow I’d like to build is: Watch changes → if column B in the orders sheet has the checkbox enabled → then take the data from that row and generate a document using a template.
Error messages or input/output bundles
How can I set this up? I’m trying to connect Google Sheets with a webhook, but it doesn’t capture any data.
Hi, you don’t need a webhook for this. Google Sheets can trigger the scenario by itself, and webhooks won’t capture row data from sheet changes.
Just use Google Sheets Watch changes (or Watch rows) as the trigger. Then add a filter that checks if the checkbox in column B is TRUE. When it is, take the data from that row and use Google Docs to create a document from your template.
That’s it. Every time someone checks the box, the document will be generated automatically.
Thanks! I connected the scenario to the sheet using the Make application within Google Sheets. When the scenario runs, it doesn’t return any data (although if I look inside the queue, I can see them). These two errors appear in the scenario: Exceeded maximum wait time, and [403] Method doesn’t allow unregistered callers (callers without established identity). Please use API Key or other form of API consumer identity to call this API
What is your goal?
What is the problem & what have you tried?
Error messages or input/output bundles