Auto-generate personalized Canva designs from Airtable rows

Whenever a new record is created in a specific Airtable table (the user picks the base, table, Canva brand template, export format, Google Drive folder, and target Airtable column at setup), generate a personalized Canva design from that brand template using the row's field values, export it, upload it to Google Drive, and write the shareable Drive URL back onto the same Airtable row.

Trigger: Airtable new_record on the user-selected base and table.

Pipeline (deterministic, one pass per new row):

1) Read the new row's fields from the trigger payload. 2) Call Canva Get Brand Template Dataset on the chosen brand template to fetch the authoritative list of placeholder names. 3) Build the autofill data map by binding each Canva placeholder to the corresponding Airtable field value (auto-match by name, or use an explicit mapping the user configured at setup). 4) Call Canva Autofill Brand Template with that data map, then poll the returned autofill job on Canva's job endpoint until status is success or failed; on success capture the new design id. 5) Call Canva Export Design on that design id with the user's chosen format (PDF or PNG), then poll the export job until it completes and the download URL is returned. 6) Download the exported file bytes from that URL. 7) Call Google Drive Upload File (Multipart) to upload the bytes into the user's chosen Drive folder, naming the file from the row (e.g. "<primary field> - <template name>.pdf"). 8) Call Airtable Update Record on the original record id, writing the file's shareable Drive URL (webViewLink) into the Airtable column the user designated.

Setup inputs to collect from the user: Airtable base and table, Canva brand template id, export format (PDF or PNG), Google Drive destination folder id, and the Airtable field name that should receive the Drive link. Optionally: an explicit column-to-placeholder mapping if the Airtable column names do not match the Canva placeholder names.

Nuance the workflow must bake in:

Canva Autofill Brand Template requires Canva Enterprise on the connected account. Detect this on the first run and fail fast with a clear, user-facing message if the account is not Enterprise, rather than silently producing empty designs.

Async jobs return a { job: { id, status } } envelope. A 2xx on the start call only confirms the job was queued. Poll the matching Canva job endpoint (typical cadence 1-2 seconds, expect completion in 10-30 seconds) and treat status=failed as a real error to surface, not as success.

Canva export download URLs expire 24 hours after the job completes, so do the Google Drive upload in the same run rather than deferring it. Google Drive Upload File (Multipart) is capped at 5MB; single-page certificates, badges, and one-pagers fit comfortably, but note this constraint if the user later swaps in a heavy multi-page template.

If any step fails (autofill job failed, unsupported export format for that design type, Drive upload rejected), write the error message into the target Airtable column (or a status column if the user has designated one) so the failure is visible on the row, rather than dropping the record silently.