n8n Form Trigger to Google Sheets with Olostep Integration

This n8n workflow automates the process of collecting data via a form, enriching it with information from the Olostep API, and then storing the results in a Google Sheet. It's designed to streamline lead generation or data collection processes that require external data enrichment.

What it does

This workflow performs the following steps:

1. Listens for Form Submissions: It starts when a new form is submitted through the n8n Form Trigger.
2. Edits Fields: It prepares the incoming data by setting or modifying specific fields, likely to format it for the subsequent API call.
3. Removes Duplicates: It ensures data quality by removing any duplicate items based on a specified field (not explicitly defined in the JSON, but implied by the node).
4. Splits Out Items: It separates items from an array into individual items, preparing them for batch processing.
5. Loops Over Items: It processes items in batches to manage API rate limits or improve performance.
6. Waits (Delay): Introduces a delay between batches or individual API calls to prevent overwhelming the API or hitting rate limits.
7. Calls Olostep API: It makes an HTTP request to the Olostep API (implied by the directory name and the HTTP Request node) to enrich the data.
8. Appends to Google Sheets: Finally, it appends the processed and enriched data as a new row to a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance to import and execute the workflow.
• Google Sheets Account: Configured credentials for Google Sheets to write data.
• Olostep API Access: An API key or credentials for the Olostep service to make HTTP requests (implied).
• n8n Form Trigger: The n8n Form Trigger URL will be generated upon activating the workflow.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New" in the workflows section.
   • Click the three dots menu (...) and select "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Locate the "Google Sheets" node and configure your Google Sheets credentials. You will likely need to select an existing credential or create a new OAuth2 credential for Google Sheets.
   • Locate the "HTTP Request" node. You will need to configure the URL, headers (e.g., for API keys), and body of the request to interact with the Olostep API.
3. Configure Nodes:
   • On form submission (Form Trigger): Activate the workflow to generate the webhook URL for your form. Use this URL in your external form to send data to n8n.
   • Edit Fields (Set): Review and adjust the fields being set or modified to match your incoming form data and the expected format for the Olostep API.
   • Remove Duplicates: Configure the key(s) on which to check for duplicates.
   • Split Out: Ensure this is configured correctly if you have nested data that needs to be flattened.
   • Loop Over Items (Split in Batches): Adjust the batch size as needed, considering Olostep API rate limits.
   • Wait: Adjust the delay duration if necessary to comply with API rate limits.
   • HTTP Request: Update the Olostep API endpoint, method (e.g., POST), headers (e.g., Authorization with your API key), and the request body to send the correct data from your form submission to Olostep.
   • Google Sheets: Specify the Google Sheet ID and the sheet name where the data should be appended. Map the fields from the enriched data to the columns in your Google Sheet.
4. Activate the Workflow: Once all configurations are complete, activate the workflow. It will then be ready to process form submissions.