Bear Brown
← All N8N workflows
Data & databasesCodeGoogle SheetsHTTP RequestIfManual Trigger

My workflow 2

Configured with Google Sheets, HTTP Request, Schedule Trigger, Loop Over Items, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗15 nodes · MIT
Workflow preview
TriggerWhen clicking ‘Testworkflow’Manual TriggerTransformXMLXmlWeb / APIGoogleTrendsHTTP RequestTransformCONFIGEdit FieldsData storeGet saved keywordsGoogle SheetsRoutingLoop Over ItemsLoop Over ItemsTransformMappingEdit FieldsData storeGoogle SheetsGoogle SheetsCodeNew keywordsCodeWeb / APIcontent1HTTP RequestWeb / APIcontent2HTTP RequestWeb / APIcontent3HTTP RequestTriggerStart every hour past11 minutesSchedule TriggerRoutingIf we have scraped min1 url -> SaveIfRoutingAll scraping nodefailed. Don't save…No Op

Node categories in this workflow

  • Trigger
  • Transform
  • Web / API
  • Data store
  • Routing
  • Code

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
XMLTransformXmlSee node parameters
GoogleTrendsWeb / APIHTTP RequestSee node parameters
CONFIGTransformEdit FieldsSee node parameters
Get saved keywordsData storeGoogle SheetsSee node parameters
Loop Over ItemsRoutingLoop Over ItemsSee node parameters
MappingTransformEdit FieldsSee node parameters
Google SheetsData storeGoogle Sheetsappend
New keywordsCodeCodeSee node parameters
content1Web / APIHTTP RequestSee node parameters
content2Web / APIHTTP RequestSee node parameters
content3Web / APIHTTP RequestSee node parameters
Start every hour past 11 minutesTriggerSchedule TriggerSee node parameters
If we have scraped min 1 url -> SaveRoutingIfSee node parameters
All scraping node failed. Don't save record without summaryRoutingNo OpSee 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

  • googleSheetsOAuth2Api

Workflow notes

Cron trigger

Cron trigger

Google Trends update the RSS feed every 10 minutes. This will start wordflow 1 minute after.

CONFIGURATION

CONFIGURATION

min_traffic is a numeric value. Google Trend RSS has an approx traffic value 100, 200, 500, 1000 etc.

max_result is a numeric value used to limit max rss to scrape

jina_key is the jina.ai API key

Google Sheet Database

Google Sheet Database

This is main sheet where all your Editorial plan will be saved.

The column status value could be a trigger for other automations

Google Trends request

Google Trends request

We get last kwyword in trend. Every item has a main keyword and 3 URL. We will use those url to scrape content and generate a combined summary

Simple conversion

Simple conversion

Converts XML RSS into a more readable json object

Building dataset

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.

Data mapping

Data mapping

Here you have all fields needed in Google Sheet.

While done, the content of 3 website linked in Google Trends RSS will be merged in a single Summary field

Data check

Data check

Sometimes scraping HTML content fails (for some reasons), that's normal but this should avoid to save a zero content if all 3 scraping nodes will fail

Scraping

Scraping

Here jina.ai will get text content from 3 Google Trends URLs

My workflow 2

My workflow 2

Purpose and structure

This folder contains the My workflow 2 workflow. Its executable nodes use code, googleSheets, httpRequest, if, manualTrigger, noOp, scheduleTrigger, set, splitInBatches, xml. 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’, Start every hour past 11 minutes

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/Code/1446_Code_Schedule_Automate_Scheduled.json MIT; preserve source notices.

Canvas section labels

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

  • Saving output

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales