Grist: On row confirmed, create row in other table
Go to WorkflowDescription
In Grist, when I mark a row as confirmed (via a toggle):
a webhook is set up to notify n8n, and this workflow will create derived records in the destination table.
Design decisions
Confirmation-based
In the source table there is a boolean column "Confirmed" that will trigger the transfer.
This way there is a manual check involved & it's a conscious step to trigger the workflow.
Runs once
If the destination table already contains an entry, we will not re-create/update it (as it might've already been changed manually)
Setup
Create a boolean column Confirmed in source table
Add a webhook in Grist Settings
Add grist API credentials in n8n
Set document ID & source table ID/Name in the 'get existing' node
Set docID, the destination table ID/Name - and the columns & values you want in the Create Row node