Data Sync & ETL
Import Google Keep Notes into Google Sheets with OpenAI
When you run it, it reads exported Google Keep notes, OpenAI processes non-archived ones and rows are saved to Google Sheets.
What it does
## 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!
The steps
- When clicking ‘Test workflow’
- Extract from File
- If is archived is false
- OpenAI Chat Model
- If extension is json
- Search in "Keep" folder
- Loop every 10 items
- Download the files
- Put some AI treatment here if you need it
- Set the fields for export
- Add to google sheet
- Filter
Similar automations
Documents, PDF & OCRProcess Google Keep Takeout JSON Notes from Drive with OpenAI into Sheets13 stepsData Sync & ETLImport Productboard Notes and Features into Snowflake33 stepsData Sync & ETLImport Productboard Notes, Companies and Features into Snowflake62 stepsFiles & Cloud StorageSave Workflow Results as Markdown Notes in Obsidian via Google Drive12 steps