n8n Form to Google Sheets and Google Drive Workflow

This n8n workflow provides a robust solution for collecting data via a web form, automatically logging submissions to a Google Sheet, and optionally uploading associated files to Google Drive. It includes logic to handle file uploads and ensures a structured logging process.

What it does

This workflow streamlines data collection and storage by:

1. Triggering on Form Submission: Listens for new submissions to an n8n web form.
2. Logging to Google Sheets: Appends the form submission data (excluding files) as a new row in a specified Google Sheet.
3. Conditional File Upload to Google Drive: Checks if a file was uploaded in the form submission.
4. Uploading Files to Google Drive: If a file is present, it uploads the file to a designated folder in Google Drive.
5. Waiting for File Processing: Introduces a short delay to ensure Google Drive has processed the uploaded file before proceeding (optional, but good practice for large files or busy systems).
6. Updating Google Sheet with File Link: Retrieves the public URL of the uploaded file from Google Drive and updates the corresponding row in the Google Sheet with this link.

Prerequisites/Requirements

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Google Account: A Google account with access to:
  • Google Sheets: A spreadsheet where form submissions will be logged.
  • Google Drive: A folder where uploaded files will be stored.
• n8n Credentials:
  • Google Sheets Credential: Configured to allow n8n to write to your Google Sheets.
  • Google Drive Credential: Configured to allow n8n to upload files to your Google Drive.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "New" in the workflows list, then "Import from JSON" and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the "Google Sheets" and "Google Drive" nodes.
   • Click on each node and select or create new "Google OAuth2 API" credentials. Ensure these credentials have the necessary permissions to read/write to your Google Sheet and upload to your Google Drive.
3. Configure the "On form submission" Trigger:
   • Open the "On form submission" node.
   • Define the fields for your form as needed. Ensure you have a field for file uploads if you intend to use that functionality.
   • After saving, activate the workflow to get the unique webhook URL for your form.
4. Configure the "Google Sheets" Nodes:
   • First "Google Sheets" node (Append Submission):
     • Set the "Spreadsheet ID" to your target Google Sheet.
     • Set the "Sheet Name" where data will be appended.
     • Map the form fields from the "On form submission" node to the columns in your Google Sheet.
   • Second "Google Sheets" node (Update with File Link):
     • Set the "Spreadsheet ID" and "Sheet Name" to match the first Google Sheets node.
     • Configure it to update the row that was just created, typically by using an ID or row index passed from the previous Google Sheets node.
     • Map the file's public URL from the "Google Drive" node to the relevant column in your Google Sheet.
5. Configure the "Google Drive" Node:
   • Set the "Folder ID" where files should be uploaded.
   • Map the file data from the "On form submission" node to the file input of the Google Drive node.
6. Activate the Workflow: Toggle the workflow to "Active" in the top right corner of the n8n editor.
7. Share Your Form: Use the webhook URL provided by the "On form submission" node to integrate your form into your website or share it directly.

Now, every time someone submits your n8n form, the data will be logged in Google Sheets, and any uploaded files will be stored in Google Drive, with their links updated in your Google Sheet.