Simeon Penev
Workflows by Simeon Penev
Create & send GA4 report with insights via email
## Who’s it for Marketing, growth, and analytics teams who want a **decision-ready GA4 summary**—automatically calculated, clearly color-coded, and emailed as a polished HTML report. ## How it works / What it does - **Get Client (Form Trigger)** collects **GA4 Property ID (“Account ID”)**, **Key Event**, **date ranges (current & previous)**, **Client Name**, and **recipient email**. - **Overall Metrics This Period / Previous Period (GA4 Data API)** pull sessions, users, engagement, bounce rate, and more for each range. - **Form Submits This Period / Previous Period (GA4 Data API)** fetch key-event counts for conversion comparisons. - **Code** normalizes form dates for API requests. - **AI Agent** builds a **valid HTML email**: - Calculates % deltas, applies **green for positive** (`#10B981`) and **red for negative** (`#EF4444`) changes. - Writes summary and recommendations. - Produces the **final HTML only**. - **Send a message (Gmail)** sends the formatted HTML report to the specified email address with a contextual subject. ## How to set up 1) Add credentials: **Google Analytics OAuth2**, **OpenAI** (Chat), **Gmail OAuth2**. 2) Ensure the form fields match your GA4 property and event names; **“Account ID” = GA4 Property ID**. Property ID - https://take.ms/vO2MG Key event - https://take.ms/hxwQi 3) Publish the form URL and run a test submission. ## Requirements GA4 property access (Viewer/Analyst) • OpenAI API key • Gmail account with send permission. ## Resources Google OAuth2 (GA4) – https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/ OpenAI credentials – https://docs.n8n.io/integrations/builtin/credentials/openai/ Gmail OAuth2 – https://docs.n8n.io/integrations/builtin/credentials/google/ GA4 Data API overview – https://developers.google.com/analytics/devguides/reporting/data/v1
Create ideal customer profile from websites content to Google Doc
## Who’s it for Growth, marketing, sales, and founder teams that want a **decision-ready Ideal Customer Profile (ICP)**—grounded in their own site content. ## How it works / What it does - **On form submission** collects **Website URL** and **Business Name** and redirects to Google Drive Folder after the final node. - **Crawl and Scrape the Website Content** - crawls and scrape **20 pages** from the website. - **ICP Creator** builds a **Markdown ICP** with: A) **Executive Summary** B) **One-Pager ICP** C) **Tiering & Lead Scoring** D) **Demand Gen & ABM Plays** E) **Evidence Log** F) **Section Confidence** **Facts vs. Inferences**, confidence scores and tables. - **Markdown to Google Doc** converts Markdown to Google Docs `batchUpdate` requests. Then this is used in **Update a document** for updating the empty doc. - **Create a document** + **Update a document** generate **“ICP for <Business Name>”** in your Drive folder and apply formatting. ## How to set up 1) Add credentials: **Firecrawl** (Authorization header), **OpenAI** (Chat), **Google Docs OAuth2**. 2) Replace placeholders: `{{API_KEY}}`, `{{google_drive_folder_id}}`, `{{google_drive_folder_url}}`. 3) Publish and open the Form URL to test. ## Requirements Firecrawl API key • OpenAI API key • Google account with access to the target Drive folder. ## Resources Google OAuth2 Credentials Setup - https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/ OpenAI API key - https://docs.n8n.io/integrations/builtin/credentials/openai/ Firecrawl API key - https://take.ms/lGcUp
Create SEO content brief from keyword to Google Doc
Who’s it for ------------ Content/SEO teams who want a fast, consistent, research-driven brief for a copywriters from a single keyword—without manual review and analysis of the SERP (Google results). How it works / What it does --------------------------- - Form Trigger collects the keyword/topic and redirects to Google Drive Folder after the final node. - FireCrawl Search & Scrape pulls the top 5 pages for the chosen keyword. - AI Agent (with Think + OpenAI Chat Model) analyzes sources and generates an original Markdown brief. - Markdown to JSON converts the Markdown into Google Docs batchUpdate requests (H1/H2/H3, lists, links, spacing). Then this is used in Update a document for updating the empty doc. - Create a document + Update a document write a Google Doc titled “SEO Brief for ” and update the Google Doc in your target Drive folder. How to set up ------------- 1. Add credentials: Firecrawl (Authorization header), OpenAI (Chat), Google Docs OAuth2. 2. Replace placeholders: {{APIKEY}}, {{googledrivefolderid}}, {{googledrivefolderurl}}. 3. Publish and open the Form URL to test. Requirements ------------ Firecrawl API key • OpenAI API key • Google account with access to the target Drive folder. Resources --------- Google OAuth2 Credentials Setup - [https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/) Firecrawl API key - [https://take.ms/lGcUp](https://take.ms/lGcUp) OpenAI API key - [https://docs.n8n.io/integrations/builtin/credentials/openai/](https://docs.n8n.io/integrations/builtin/credentials/openai/)