n8n

How to Automate Google Drive to Sheets Content Summaries?

New files land in team folders all day. This setup reads each new Google Doc, creates a short AI summary, and logs it to Google Sheets for quick review. It fits teams that need fast takeaways from reports, meeting notes, or briefs.

A Google Drive trigger watches a selected folder every minute for newly created files. When a new Google Doc appears, a Google Docs node pulls the full text using the file id. An AI node using the GPT 4o mini model turns that text into a clear summary. The flow then appends the summary, the document name, and the editor details to a target sheet. Optional Wikipedia and Calculator tools can help the AI explain terms or do quick math when needed.

Setup needs Google access and an OpenAI key, a folder to watch, and a spreadsheet ID. Expect faster review cycles and fewer context switches because answers live in one place. Use it for marketing content reviews, sales playbook notes, team meeting summaries, and policy updates. After testing, activate the workflow so it runs automatically for every new document.

What are the key features?

  • Google Drive trigger watches a specific folder for new files every minute
  • Google Docs get operation reads the full document content using the file id
  • AI summarization with GPT 4o mini produces a concise, readable summary
  • Optional Wikipedia and Calculator tools support the AI with terms and quick math
  • Google Sheets append adds summary and metadata to your chosen sheet
  • Captures last modifying user name and email for clear ownership tracking
  • Configurable folder and sheet targets so teams can route summaries to the right place

What are the benefits?

  • Reduce manual reading time per document from 10 minutes to 30 seconds
  • Streamline document review by about 80 percent with automatic summaries
  • Improve data consistency by pulling editor name and email from Drive metadata
  • Handle higher volume with a one minute folder check for new files
  • Connect Google Drive, Google Docs, OpenAI, and Google Sheets in one flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Drive, Google Docs, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. Open the Google Drive trigger node. In the credential field, click Create new credential and follow the on screen instructions to connect your Google account. Set the event to file created, choose Specific folder, and paste the folder link you want to watch. Keep the poll interval at every minute for near real time checks.
  4. Open the Google Docs node. In the credential dropdown, click Create new credential and follow the on screen steps to connect Google Docs. Confirm the Document URL or ID field uses the file id from the trigger, for example {{ $json.id }}. Make sure the files added to the folder are native Google Docs or are converted to Google Docs format.
  5. Open the Generate Summary AI node. In the credential field, click Create new credential, select OpenAI, and paste your API key from your OpenAI account. Select the GPT 4o mini model. Keep the prompt that asks for a concise summary or tweak it to match your style.
  6. Open the Google Sheets node. In the credential field, click Create new credential and connect your Google account. Paste the spreadsheet link into the Document ID field and select your sheet name. Map the columns for document name, editor name, editor email, and summary as shown in the template.
  7. Optional tools: Leave Wikipedia and Calculator tools connected to the AI node. They do not need extra credentials and can help the AI with terms and quick math.
  8. Test the flow: Add a new Google Doc to the watched folder. In n8n, click Execute test to run once. Confirm the Google Sheets row appears with the summary and metadata.
  9. Activate the workflow: Toggle the workflow to active so the trigger runs on schedule. Watch the first few runs in the Execution list to confirm stable behavior.
  10. Troubleshooting: If the Docs node fails, confirm the file is a Google Doc and you have access. If the Sheets node errors, share the spreadsheet with the same Google account used in credentials. If nothing triggers, verify the folder link and that the event is set to file created.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Docs

Sign up

Free: $0, Google Docs API usage at no additional cost (quota limits apply)

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.