Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

Data Sync & ETL

Automate Google Sheets

When you run it, it moves and syncs data using Google Sheets.

Import it free Sign in to open it

What it does

## Building dataset Here we limits results, filter by mmin traffic and we flat the RSS structure to adapt to Google Sheet, fields are renamed as per description. Then RSS result and Google Sheet is compared, if a new keyword is found we have result. If RSS give a keyword already srtored, this node doesn't give any output.

The steps

  1. When clicking ‘Test workflow’
  2. XML
  3. GoogleTrends
  4. CONFIG
  5. Get saved keywords
  6. Loop Over Items
  7. Mapping
  8. Google Sheets
  9. New keywords
  10. content1
  11. content2
  12. content3
  13. Start every hour past 11 minutes
  14. If we have scraped min 1 url -> Save

15 steps in total.

Similar automations

Email AutomationAutomate Pinterest Analysis & AI-Powered Content Suggestions With Pinterest API10 stepsEmail AutomationAutomate Pinterest Analysis & AI-Powered Content Suggestions With Pinterest API10 stepsData Sync & ETLLog Daily Mood and Weather to Notion via Telegram12 stepsCalendar & SchedulingCreate Google Calendar Events from Google Sheets Entries3 steps