Back to Integrations
integrationGoogle Drive node
integrationGoogle Sheets node

Google Drive and Google Sheets integration

Save yourself the work of writing custom integrations for Google Drive and Google Sheets and use n8n instead. Build adaptable and scalable Data & Storage, and Productivity workflows that work with your technology stack. All within a building experience you will love.

How to connect Google Drive and Google Sheets

  • Step 1: Create a new workflow
  • Step 2: Add and configure nodes
  • Step 3: Connect
  • Step 4: Customize and extend your integration
  • Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google Drive and Google Sheets integration: Create a new workflow and add the first step

Step 2: Add and configure Google Drive and Google Sheets nodes

You can find Google Drive and Google Sheets in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure Google Drive and Google Sheets nodes one by one: input data on the left, parameters in the middle, and output data on the right.

Google Drive and Google Sheets integration: Add and configure Google Drive and Google Sheets nodes

Step 3: Connect Google Drive and Google Sheets

A connection establishes a link between Google Drive and Google Sheets (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Google Drive and Google Sheets integration: Connect Google Drive and Google Sheets

Step 4: Customize and extend your Google Drive and Google Sheets integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Google Drive and Google Sheets with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Google Drive and Google Sheets integration: Customize and extend your Google Drive and Google Sheets integration

Step 5: Test and activate your Google Drive and Google Sheets workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Google Drive to Google Sheets or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Google Drive and Google Sheets integration: Test and activate your Google Drive and Google Sheets workflow

AI Automated HR Workflow for CV Analysis and Candidate Evaluation

How it Works

This workflow automates the process of handling job applications by extracting relevant information from submitted CVs, analyzing the candidate's qualifications against a predefined profile, and storing the results in a Google Sheet. Here’s how it operates:

Data Collection and Extraction:
The workflow begins with a form submission (On form submission node), which triggers the extraction of data from the uploaded CV file using the Extract from File node.
Two informationExtractor nodes (Qualifications and Personal Data) are used to parse specific details such as educational background, work history, skills, city, birthdate, and telephone number from the text content of the CV.

Processing and Evaluation:
A Merge node combines the extracted personal and qualification data into a single output.
This merged data is then passed through a Summarization Chain that generates a concise summary of the candidate’s profile.
An HR Expert chain evaluates the candidate against a desired profile (Profile Wanted), assigning a score and providing considerations for hiring.
Finally, all collected and processed data including the evaluation results are appended to a Google Sheets document via the Google Sheets node for further review or reporting purposes [[9]].

Set Up Steps

To replicate this workflow within your own n8n environment, follow these steps:

Configuration:
Begin by setting up an n8n instance if you haven't already; you can sign up directly on their website or self-host the application.
Import the provided JSON configuration into your n8n workspace. Ensure that all necessary credentials (e.g., Google Drive, Google Sheets, OpenAI API keys) are correctly configured under the Credentials section since some nodes require external service integrations like Google APIs and OpenAI for language processing tasks.

Customization:
Adjust the parameters of each node according to your specific requirements. For example, modify the fields in the formTrigger node to match what kind of information you wish to collect from applicants.
Customize the prompts given to AI models in nodes like Qualifications, Summarization Chain, and HR Expert so they align with the type of analyses you want performed on the candidates' profiles.
Update the destination settings in the Google Sheets node to point towards your own spreadsheet where you would like the final outputs recorded.

Nodes used in this workflow

Popular Google Drive and Google Sheets workflows

+3

✨🔪 Advanced AI Powered Document Parsing & Text Extraction with Llama Parse

Description This workflow automates document processing using LlamaParse to extract and analyze text from various file formats. It intelligently processes documents, extracts structured data, and delivers actionable insights through multiple channels. How It Works Document Ingestion & Processing 📄 Monitors Gmail for incoming attachments or accepts documents via webhook Validates file formats against supported LlamaParse extensions Uploads documents to LlamaParse for advanced text extraction Stores original documents in Google Drive for reference Intelligent Document Analysis 🧠 Automatically classifies document types (invoices, reports, etc.) Extracts structured data using customized AI prompts Generates comprehensive document summaries with key insights Converts unstructured text into organized JSON data Invoice Processing Automation 💼 Extracts critical invoice details (dates, amounts, line items) Organizes financial data into structured formats Calculates tax breakdowns, subtotals, and payment information Maintains detailed records for accounting purposes Multi-Channel Delivery 📱 Saves extracted data to Google Sheets for tracking and analysis Sends concise summaries via Telegram for immediate review Creates searchable document archives in Google Drive Updates spreadsheets with structured financial information Setup Steps Configure API Credentials 🔑 Set up LlamaParse API connection Configure Gmail OAuth for email monitoring Set up Google Drive and Sheets integrations Add Telegram bot credentials for notifications Customize AI Processing ⚙️ Adjust document classification parameters Modify extraction templates for specific document types Fine-tune summary generation prompts Customize invoice data extraction schema Test and Deploy 🚀 Test with sample documents of various formats Verify data extraction accuracy Confirm notification delivery Monitor processing pipeline performance
+2

Invoices from Gmail to Drive and Google Sheets

Attachments Gmail to Drive and Google Sheets Description Automatically process invoice emails by saving attachments to Google Drive and extracting key invoice data to Google Sheets using AI. This workflow monitors your Gmail for unread emails with attachments, saves PDFs to a specified Google Drive folder, and uses OpenAI's GPT-4o to extract invoice details (date, description, amount) into a structured spreadsheet. Use cases Invoice Management**: Automatically organize and track invoices received via email Financial Record Keeping**: Maintain a structured database of all invoice information Document Organization**: Keep digital copies of invoices organized in Google Drive Automated Data Entry**: Eliminate manual data entry for invoice processing Resources Gmail account Google Drive account Google Sheets account OpenAI API key Setup instructions Prerequisites Active Gmail, Google Drive, and Google Sheets accounts OpenAI API key (GPT-4o model access) n8n instance with credentials manager Steps Gmail and Google Drive Setup: Connect your Gmail account in n8n credentials Connect your Google Drive account with appropriate permissions Create a destination folder in Google Drive for invoice storage Google Sheets Setup: Connect your Google Sheets account Create a spreadsheet with columns: Invoice date, Invoice Description, Total price, and Fichero Copy your spreadsheet ID for configuration OpenAI Setup: Add your OpenAI API key to n8n credentials Configure Email Filter: Update the email filter node to match your specific sender requirements Benefits Time Saving**: Eliminates manual downloading, filing, and data entry Accuracy**: AI-powered data extraction reduces human error Organization**: Consistent file naming and storage structure Searchability**: Creates a searchable database of all invoice information Automation**: Runs every minute to process new emails as they arrive Related templates Email Parser to CRM Document Processing Workflow Financial Data Automation
+2

AI Automated HR Workflow for CV Analysis and Candidate Evaluation

How it Works This workflow automates the process of handling job applications by extracting relevant information from submitted CVs, analyzing the candidate's qualifications against a predefined profile, and storing the results in a Google Sheet. Here’s how it operates: Data Collection and Extraction: The workflow begins with a form submission (On form submission node), which triggers the extraction of data from the uploaded CV file using the Extract from File node. Two informationExtractor nodes (Qualifications and Personal Data) are used to parse specific details such as educational background, work history, skills, city, birthdate, and telephone number from the text content of the CV. Processing and Evaluation: A Merge node combines the extracted personal and qualification data into a single output. This merged data is then passed through a Summarization Chain that generates a concise summary of the candidate’s profile. An HR Expert chain evaluates the candidate against a desired profile (Profile Wanted), assigning a score and providing considerations for hiring. Finally, all collected and processed data including the evaluation results are appended to a Google Sheets document via the Google Sheets node for further review or reporting purposes [[9]]. Set Up Steps To replicate this workflow within your own n8n environment, follow these steps: Configuration: Begin by setting up an n8n instance if you haven't already; you can sign up directly on their website or self-host the application. Import the provided JSON configuration into your n8n workspace. Ensure that all necessary credentials (e.g., Google Drive, Google Sheets, OpenAI API keys) are correctly configured under the Credentials section since some nodes require external service integrations like Google APIs and OpenAI for language processing tasks. Customization: Adjust the parameters of each node according to your specific requirements. For example, modify the fields in the formTrigger node to match what kind of information you wish to collect from applicants. Customize the prompts given to AI models in nodes like Qualifications, Summarization Chain, and HR Expert so they align with the type of analyses you want performed on the candidates' profiles. Update the destination settings in the Google Sheets node to point towards your own spreadsheet where you would like the final outputs recorded.
+17

🐶 AI Agent for PetShop Appointments (Agente de IA para agendamentos de PetShop)

🐶🤖 AI Agent for Pet Shops – Automate Customer Service & Bookings! 🐾💡 Transform Your Pet Shop with AI-Powered Automation! 🚀 Enhance customer experience and optimize operations with this n8n AI Agent designed for pet shops. 📲🐾 Automate client interactions, appointment scheduling, and service recommendations—saving time and increasing revenue! 🔹 Key Features: ✅ Instant WhatsApp responses – AI-powered chatbot handles customer inquiries. 💬 ✅ Automated appointment scheduling – Clients can book services hassle-free. 📅✂️ ✅ Personalized reminders – Reduce no-shows with automated notifications. 📢🐾 ✅ Customer data & service history management – Track interactions effortlessly. 📊📁 ✅ Product & service recommendations – Improve sales with smart suggestions. 🎁🐶 📌 How It Works 1️⃣ The workflow captures customer inquiries via WhatsApp. 2️⃣ AI processes requests, provides information, and offers booking options. 3️⃣ Clients can schedule grooming, vet visits, or other services in seconds. 4️⃣ Automated reminders ensure appointments are remembered. 5️⃣ Customer data is stored for better service personalization. ⚙️ Setup & Customization 🔧 Connect your WhatsApp API (evolution) for instant messaging. 🔧 Integrate with Google Calendar for appointment booking. 🔧 Customize reminders, services, and pricing rules to fit your business. 💡 Reduce manual work, improve customer satisfaction, and scale your pet shop with AI automation! 🐶🤖 [PT-BR] Agente de IA para Pet Shops – Atendimento e Agendamentos Automatizados! 🐾💡 Transforme Seu Pet Shop com Automação Inteligente! 🚀 Otimize o atendimento ao cliente e agilize processos com este Agente de IA para n8n. 📲🐾 Automatize interações, agendamentos e recomendações de serviços—economizando tempo e aumentando as vendas! 🔹 Principais Funcionalidades: ✅ Atendimento automático no WhatsApp – IA responde clientes instantaneamente. 💬 ✅ Agendamento de serviços automatizado – Clientes marcam banho, tosa ou consultas facilmente. 📅✂️ ✅ Lembretes personalizados – Reduza faltas com notificações automáticas. 📢🐾 ✅ Gestão de clientes e histórico de serviços – Controle dados de forma eficiente. 📊📁 ✅ Sugestão de produtos e serviços – Venda mais com recomendações inteligentes. 🎁🐶 📌 Como Funciona 1️⃣ O fluxo recebe perguntas dos clientes via WhatsApp. 2️⃣ A IA processa os pedidos e fornece opções de agendamento. 3️⃣ O cliente escolhe o serviço desejado e agenda em segundos. 4️⃣ Lembretes automáticos garantem que os clientes não esqueçam os horários. 5️⃣ O histórico do cliente é salvo para oferecer um atendimento mais personalizado. ⚙️ Configuração e Personalização 🔧 Conecte sua API do WhatsApp (evolution) para interação automática. 🔧 Integre ao Google Calendar para gerenciar agendamentos. 🔧 Personalize valores, serviços e regras de envio de lembretes conforme sua necessidade. 💡 Automatize processos, melhore a experiência do cliente e escale seu pet shop com IA! 🚀
+4

WordPress Auto-Blogging Pro - Content Automation Machine for SEO topics

The best content automation in the market! This advanced workflow not only creates and publishes SEO-optimized blog posts to your WordPress website but also backs up all content and images to a designated folder in your Google Drive. In addition, It generates a unique image for each chapter and a featured image for the overall article, and it automatically collects internal website links—seamlessly inserting them throughout each chapter and the entire article. This integrated approach enhances on-page SEO, improves navigation, and streamlines your content creation process, saving you time while ensuring your work is securely stored. How it works Triggers upon adding a new row to a Google Sheets. Generates a full blog post by writing content based on customizable parameters such as topic, target audience, length, style, and seed keyword. Generates and adds images for each chapter as well as a featured image for the article. Gathers internal website links and strategically embeds them within each chapter and throughout the article, boosting SEO and enhancing user navigation. Publishes the blog post directly to your WordPress website. Saves all content (blog post and images) to Google Drive, organizing them in a folder named after the blog post title. Unique features Full Automation: The workflow is designed to be 100% automated. Once imported and configured, it can run without manual intervention. Simple Activation: It can be easily triggered through the Google Spreadsheets interface. You simply add a new row to a Google Sheet. Customization Options: Offers a wide array of customization options, including topic, category, target audience, word count, number of chapters, length of introduction and conclusion, and writing style. It also allows for the inclusion of calls-to-action (CTAs) and company/product introductions. Automatic Content Saving: After writing a blog post, all content and images are automatically saved to Google Drive, preventing data loss. The folder is even named after the title of the blog post. SEO-Optimized Content: It's designed to create content optimized for SEO using seed keywords. AI Model Flexibility: It’s super easy to switch between different AI models through the Open Router node. Rate Limit Handling: Includes "Wait" nodes to avoid rate limits. Internal Link Limit: Limits the number of internal links to 20 by default. Set up steps Install the workflow template: Import the JSON file into your n8n instance. Connect the workflow to your accounts: This includes linking your WordPress website, Google Drive, and AI models (such as OpenAI GPT-4o). Configure the Google Sheet: Ensure your Google Sheet is set up to trigger the workflow upon adding a new row and that the input data is correctly formatted. Customize the workflow: Adjust parameters like topic, target audience, and writing style to match your specific content needs. Optimize prompts for best results. Test the workflow: Use low-cost AI models and image settings initially to ensure everything runs smoothly. Tailor Further as Needed: Modify workflow elements to align perfectly with your needs and content strategy.

Generate multispeaker podcast 🎙️ with AI natural-sounding 🤖🧠 & Google Sheets

This workflow automates the generation of multi-speaker podcasts using AI-powered text-to-speech technology. It starts by retrieving a podcast script from a Google Sheets document, where each speaker’s lines are clearly defined. The workflow then processes the script, generates a natural-sounding audio file with different voices for each speaker, and stores the final audio file in Google Drive. The workflow is designed to save time and resources by automating the podcast production process, making it ideal for content creators, marketers, and businesses that need to produce high-quality audio content regularly. How It Works Triggering the Workflow: The workflow starts with the When clicking ‘Test workflow’ node, which can be triggered manually to begin the process. Data Retrieval: The Get Podcast text node retrieves data from a Google Sheets document containing the podcast script. The document includes columns for the speaker's name and the corresponding text. Data Aggregation: The Get all rows node aggregates the data from the Google Sheets document, combining the speaker names and their respective text into a single dataset. Text Formatting: The Full Podcast Text node processes the aggregated data, formatting it into a single string where each speaker's text is prefixed with their name. Audio Generation: The Create Audio node sends a request to the API to generate a multi-speaker podcast audio file. The request includes the formatted text and specifies the voices for each speaker. When you register for the API service you will get 1$ for free. For continuous work add API credits to your account. Status Check: The Get status node checks the status of the audio generation request. If the status is "COMPLETED", the workflow proceeds; otherwise, it waits again. Audio Retrieval: The Get Url Audio node retrieves the URL of the generated audio file. The Get File Audio node downloads the audio file from the provided URL. Audio Storage: The Upload Audio node uploads the generated audio file to a specified Google Drive folder for storage. Key Features Multi-Speaker Support**: Generates podcasts with different voices for each speaker, creating a more dynamic and engaging listening experience. Google Sheets Integration**: Retrieves podcast scripts from a Google Sheets document, making it easy to manage and update content. AI-Powered Text-to-Speech**: Uses advanced AI models to generate natural-sounding audio from text. Automated Audio Generation**: Streamlines the process of creating podcast audio files, reducing the need for manual recording and editing. Google Drive Storage**: Automatically uploads the generated audio files to Google Drive for easy access and sharing. This workflow is ideal for businesses and content creators looking to automate the production of multi-speaker podcasts. It leverages AI to handle the complex task of generating natural-sounding audio, allowing users to focus on creating compelling content.

Build your own Google Drive and Google Sheets integration

Create custom Google Drive and Google Sheets workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google Drive supported actions

Copy
Create a copy of an existing file
Create From Text
Create a file from a provided text
Delete
Permanently delete a file
Download
Download a file
Move
Move a file to another folder
Share
Add sharing permissions to a file
Update
Update a file
Upload
Upload an existing file to Google Drive
Search
Search or list files and folders
Create
Create a folder
Delete
Permanently delete a folder
Share
Add sharing permissions to a folder
Create
Create a shared drive
Delete
Permanently delete a shared drive
Get
Get a shared drive
Get Many
Get the list of shared drives
Update
Update a shared drive

Google Sheets supported actions

Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet

FAQs

  • Can Google Drive connect with Google Sheets?

  • Can I use Google Drive’s API with n8n?

  • Can I use Google Sheets’s API with n8n?

  • Is n8n secure for integrating Google Drive and Google Sheets?

  • How to get started with Google Drive and Google Sheets integration in n8n.io?

Need help setting up your Google Drive and Google Sheets integration?

Discover our latest community's recommendations and join the discussions about Google Drive and Google Sheets integration.
Sergey Komardenkov
sérgio eduardo floresta filho
hubschrauber
Jon
David O'Neil

Looking to integrate Google Drive and Google Sheets in your company?

Over 3000 companies switch to n8n every single week

Why use n8n to integrate Google Drive with Google Sheets

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon