Bear Brown
← All N8N workflows
AI & researchAgentExtract From FileFilterGoogle DriveGoogle Sheets

Create an empty google sheet file

Configured with Agent, Extract From File, Filter, Google Drive, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗12 nodes · MIT
Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerTransformExtract from FileExtract From FileRoutingIf is archived is falseIfAI & modelsOpenAI Chat ModelOpenAI Chat ModelRoutingIf extension is jsonFilterFiles / mediaSearch in "Keep" folderGoogle DriveRoutingLoop every 10 itemsLoop Over ItemsFiles / mediaDownload the filesGoogle DriveAI & modelsPut some AI treatmenthere if you need itAgentTransformSet the fields forexportEdit FieldsData storeAdd to google sheetGoogle SheetsRoutingFilterIf

Node categories in this workflow

  • Trigger
  • Transform
  • Routing
  • AI & models
  • Files / media
  • Data store

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
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Extract from FileTransformExtract From FilefromJson
If is archived is falseRoutingIfSee node parameters
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
If extension is jsonRoutingFilterSee node parameters
Search in "Keep" folderFiles / mediaGoogle DrivefileFolder
Loop every 10 itemsRoutingLoop Over ItemsSee node parameters
Download the filesFiles / mediaGoogle Drivedownload
Put some AI treatment here if you need itAI & modelsAgentSee node parameters
Set the fields for exportTransformEdit FieldsSee node parameters
Add to google sheetData storeGoogle SheetsappendOrUpdate
FilterRoutingIfSee 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

  • googleDriveOAuth2Api
  • googleSheetsOAuth2Api
  • openAiApi

Workflow notes

How to export your Google keep notes

How to export your Google keep notes

  • Google has a dedicated service for exporting your google data, called Google Takeout, you'll have to login it.
  • Click on "Deselect all" then select only Google Keep and click on "Next".
  • Select the destination (use "Send download link via mail" as you'll have to uncompress a zip file before to send it again to Google Drive)
  • Upload to Google Drive all json files from your uncompresed file, to specific directory and you are ready to start!
Put some AI treatment here if you need it

Yu can use this AI Agent to process a number or anything you need from your notes

Create an empty google sheet file

Create an empty google sheet file

That will get your entries from the notes

Filter the files

Filter the files

If you need the content to contain a word, or after a certain date.

If you don't need to filter it, just remove the node

Process each file with AI

Process each file with AI

If you need the extract some information from the contextq, you can do it here. If you don't need it, just delete the node

Setup

Setup

  • Export your Google Keep notes (see "how to export your Google Keep notes")

  • Connect Google Drive, OpenAI, and Google Sheets in n8n.

  • Set the correct folder path for your notes in the “Search in ‘Keep’ folder” node.

  • Point the Google Sheet node to your spreadsheet

Create an empty google sheet file

Create an empty google sheet file

Purpose and structure

This folder contains the Create an empty google sheet file workflow. Its executable nodes use agent, extractFromFile, filter, googleDrive, googleSheets, if, lmChatOpenAi, manualTrigger, set, splitInBatches. 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

When clicking ‘Test workflow’

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/Filter/0849_Filter_Extractfromfile_Create_Triggered.json MIT; preserve source notices.

Canvas section labels

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

  • Set the directory Where you put the files
  • Contact me

More in AI & research

"Hey Siri, Ask Agent" workflow#️⃣Nostr #damus AI Powered Reporting + Gmail + Telegram(G) - Email Classification