Step 2: Store the Submitted Domain

Capture the form input and normalize it for downstream use.

1. Add the Store Site Variable node after Form Input Trigger.
2. In Assignments, set Name to website.
3. Set Value to {{ $json.Website }}.
4. Confirm the connection path: Form Input Trigger → Store Site Variable.

Step 3: Call the Competitor API and Validate the Payload

Send the domain to the API and validate the response before logging results.

1. Add Competitor API Call and connect it from Store Site Variable.
2. Set URL to https://competitor-analysis2.p.rapidapi.com/competitor.php and Method to POST.
3. Enable Send Body and set Content Type to multipart-form-data.
4. In Body Parameters, set website to {{ $json.website }}.
5. In Header Parameters, set x-rapidapi-host to competitor-analysis2.p.rapidapi.com and x-rapidapi-key to [CONFIGURE_YOUR_API_KEY].
6. Add Validate API Payload and connect it from Competitor API Call.
7. In Validate API Payload, keep the four conditions that check: {{ $json.data }}, {{ $json.data.semrushAPI.organicCompetitors }}, {{ $json.data.semrushAPI.organicPages }}, and {{ $json.data.semrushAPI.domainOrganicSearchKeywords }} are not empty.

Step 4: Configure Google Sheets Outputs

Log valid API results to one sheet and missing data to another path.

1. Add Append Results Sheet on the true output of Validate API Payload.
2. Set Operation to append and Authentication to serviceAccount.
3. Map columns in Append Results Sheet to:
   • Domain → {{ $('Store Site Variable').item.json.website }}
   • Organic Page → {{ $json.data.semrushAPI.organicPages }}
   • Organic competitor → {{ $json.data.semrushAPI.organicCompetitors }}
   • Domain organic search → {{ $json.data.semrushAPI.domainOrganicSearchKeywords }}
4. Add Delay Step on the false output of Validate API Payload.
5. Connect Delay Step → Log Missing Data and set Operation to append with Authentication serviceAccount.
6. Map columns in Log Missing Data to:
   • Domain → {{ $('Store Site Variable').item.json.website }}
   • Organic Page → =Not data found.
   • Organic competitor → =Not data found.
   • Domain organic search → =Not data found.
7. Verify the routing: Validate API Payload → Append Results Sheet (true), and Validate API Payload → Delay Step → Log Missing Data (false).
8. Credential Required: Connect your googleApi credentials in Append Results Sheet.
9. Credential Required: Connect your googleApi credentials in Log Missing Data.

Step 5: Test and Activate Your Workflow

Validate the end-to-end flow before enabling the workflow in production.

1. Click Execute Workflow and submit the form in Form Input Trigger using a test domain.
2. Confirm that Competitor API Call returns data and that Validate API Payload routes correctly.
3. Check your Google Sheet to verify a new row is appended by Append Results Sheet, or by Log Missing Data if the API response is missing fields.
4. Once verified, toggle the workflow to Active so the form can accept real submissions.