n8n Workflow: Google Sheets Trigger and HTTP Request

This n8n workflow demonstrates a basic integration pattern where an event in Google Sheets can trigger an HTTP request. It serves as a foundational example for connecting spreadsheet data changes to external APIs or services.

What it does

This workflow is designed to:

1. Listen for Google Sheets changes: It acts as a trigger, starting the workflow whenever a specified event occurs in a connected Google Sheet (e.g., new row added, row updated).
2. Make an HTTP Request: Upon being triggered, it executes an HTTP request to a defined endpoint. This allows data from the Google Sheet event to be sent to another system or API.
3. Respond to Webhook (Optional): If the workflow is initiated by an external webhook, it can send a response back to the calling service, indicating success or providing relevant data.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for your Google account to allow access to Google Sheets.
• Target API/Service: An endpoint for the HTTP Request node to send data to.

Setup/Usage

1. Import the Workflow:
   • Save the provided JSON content as a .json file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots menu (...) in the top right and select "Import from JSON".
   • Upload the saved JSON file.
2. Configure Google Sheets Trigger (Node: Google Sheets Trigger):
   • Click on the Google Sheets Trigger node.
   • Select or create a Google Sheets credential.
   • Specify the "Spreadsheet ID" and "Sheet Name" you want to monitor.
   • Choose the "Trigger Event" (e.g., "Row Added", "Row Updated") that should initiate the workflow.
   • Activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.
3. Configure HTTP Request (Node: HTTP Request):
   • Click on the HTTP Request node.
   • Enter the "URL" of the API or service you want to send data to.
   • Select the appropriate "HTTP Method" (e.g., POST, GET).
   • Configure any necessary "Headers" or "Body Parameters" to send data from the Google Sheet event. You can reference data from the Google Sheets Trigger node using expressions (e.g., {{ $json.columnName }}).
4. Configure Webhook (Node: Webhook):
   • If you intend for this workflow to be triggered by an external webhook instead of (or in addition to) the Google Sheets trigger, configure the Webhook node.
   • Copy the "Webhook URL" provided by this node. This URL will be used by external services to send data to your workflow.
5. Configure Respond to Webhook (Node: Respond to Webhook):
   • If the workflow is triggered by an external webhook and you want to send a custom response back, configure this node.
   • You can set the "Response Mode", "Response Body", and "Response Headers" as needed.
6. Activate the Workflow:
   • Once all nodes are configured, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.

Now, any changes in your specified Google Sheet (or incoming data to the Webhook) will trigger the workflow, and an HTTP request will be made.