Bear Brown
← All N8N workflows
Data & databasesAirtableCodeGoogle DriveGoogle Drive TriggerHTTP Request

Replace Google Drive connection

Configured with Airtable, Google Drive, Google Drive Trigger, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗9 nodes · MIT
Workflow preview
Files / mediaGoogle DriveGoogle DriveWeb / APIUpload FileHTTP RequestTriggerGoogle Drive TriggerGoogle Drive TriggerData storeCreate InvoiceAirtableData storeCreate Line ItemAirtableWeb / APIOpenAI - Extract LineItemsHTTP RequestTransformSet FieldsEdit FieldsCodeProcess Line ItemsCodeTriggerWebhookWebhook

Node categories in this workflow

  • Files / media
  • Web / API
  • Trigger
  • Data store
  • Transform
  • Code

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Google DriveFiles / mediaGoogle Drivedownload
Upload FileWeb / APIHTTP RequestPOST
Google Drive TriggerTriggerGoogle Drive TriggerSee node parameters
Create InvoiceData storeAirtablecreate
Create Line ItemData storeAirtablecreate
OpenAI - Extract Line ItemsWeb / APIHTTP RequestPOST
Set FieldsTransformEdit FieldsSee node parameters
Process Line ItemsCodeCodeSee node parameters
WebhookTriggerWebhookSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • airtableTokenApi
  • googleDriveOAuth2Api
  • openAiApi

Workflow notes

... or watch set up video [7 min]

... or watch set up video [7 min]

AI Agent for realtime insights on meetings

AI Agent for realtime insights on meetings

Made by Mark Shcherbakov from community 5minAI

Transcribing meetings manually can be tedious and prone to error. This workflow automates the transcription process in real-time, ensuring that key discussions and decisions are accurately captured and easily accessible for later review, thus enhancing productivity and clarity in communications.

The workflow leverages n8n and LlamaParse to automatically detect new invoices in a designated Google Drive folder, parse essential billing details, and store the extracted data in a structured format. The key functionalities include:

  • Real-time detection of new invoices via Google Drive triggers.
  • Automated HTTP requests to initiate parsing through Lama Cloud.
  • Structured storage of invoice details and line items in a database for future reference.
  1. Google Drive Integration: Monitors a specific folder in Google Drive for new invoice uploads.
  2. Parsing with LlamaParse: Automatically sends invoices for parsing and processes results through webhooks.
  3. Data Storage in Airtable: Creates records for invoices and their associated line items, allowing for detailed tracking.
Set up steps

Set up steps

  1. Google Drive Trigger:

    • Set up a trigger to detect new files in a specified folder dedicated to invoices.

  2. File Upload to LlamaParse:

    • Create an HTTP request that sends the invoice file to LlamaParse for parsing, including relevant header settings and webhook URL.

  3. Webhook Processing:

    • Establish a webhook node to handle parsed results from LlamaParse, extracting needed invoice details effectively.

  4. Invoice Record Creation:

    • Create initial records for invoices in your database using the parsed details received from the webhook.

  5. Line Item Processing:

    • Transform string data into structured line item arrays and create individual records for each item linked to the main invoice.
Replace Google Drive connection

Replace Google Drive connection

Purpose and structure

This folder contains the Replace Google Drive connection workflow. Its executable nodes use airtable, code, googleDrive, googleDriveTrigger, httpRequest, set, webhook. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Google Drive Trigger, Webhook

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Code/0669_Code_Webhook_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Scenario 1
  • Scenario 2
  • Replace Google Drive connection
  • Replace API key in header
  • Replace OpenAI connection
  • Replace Airtable connection

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales