Sync new Kajabi form submissions into Google Sheets

Build a code workflow that runs on a cron trigger every 15 minutes and copies new Kajabi form submissions into a designated Google Sheet as new rows. The flow is purely deterministic field mapping, no agent reasoning.

Trigger: cron, every 15 minutes.

Step 1. Call Kajabi List Form Submissions filtered by site_id and by created_at greater than the last successful run timestamp (store the high-water mark in workflow state so subsequent runs only pick up new submissions). Page through results until exhausted, sorted by created_at ascending so we preserve submission order. If this is the first ever run, default the cutoff to now minus 15 minutes.

Step 2. For each submission, build a row of values in this order: submission timestamp (ISO), form name, email, first name, last name, and a concatenated string of any custom answers (label: value pairs joined by semicolons). Skip any submission missing an email.

Step 3. Call Google Sheets Append Values once per run with all the new rows batched together. Target a spreadsheet ID and sheet/tab name the user configures at setup. Use valueInputOption USER_ENTERED so timestamps render as dates and emails stay as text. The sheet is assumed to already have a header row with matching columns.

Step 4. Update the stored high-water mark to the created_at of the latest submission appended, so the next run starts exactly where this one left off. If no submissions were returned, leave the high-water mark unchanged and exit cleanly.

Configurable inputs at setup: Kajabi site ID, optional list of form IDs to include (default: all forms on the site), Google Sheets spreadsheet ID, sheet/tab name, and the column order the user wants. Surface these as workflow inputs so the user can edit them later without re-authoring.

Required integrations: Kajabi (List Form Submissions) and Google Sheets (Append Values).