Automate google analytics reporting
Automate Google Analytics Reporting with n8n This n8n workflow collects, processes, and formats Google Analytics data into a comprehensive HTML report. The report is segmented into three primary categories: Engagement Stats, Search Results, and Country Views. The formatted report can be emailed or saved as a document, and the workflow includes error handling and logging for better debugging. Overview Purpose To automate the extraction, processing, and presentation of Google Analytics data in a visually appealing and structured format for easier insights and decision-making. Features Data Parsing: Individual parsers process raw Google Analytics data for different time periods and categories. Data Aggregation: Combines parsed data into a single structured JSON object. HTML Report Generation: Formats the aggregated data into an HTML table with color-coded segments for better readability. Email or Document Output: The formatted report can be emailed or saved as a Google Doc (will need additional setup). Error Handling: Includes checks for missing data and detailed error messages for debugging. Workflow Steps Data Fetching: Six separate Google Analytics data pulls: Page Engagement Stats (This Week and Prior Week) Google Search Results (This Week and Prior Week) Country Views (This Week and Prior Week) Data Parsing: Each data pull is processed using a dedicated parser node to generate a URL-safe string. Example nodes: Parse - Get Page Engagement This Week Parse - Country Views Prior Week Data Aggregation: Aggregates parsed data into a structured JSON object using the Aggregate Data node. Ensures consistency and handles missing or malformed data. HTML Report Generation: Creates a formatted HTML report with color-coded tables for each segment: Engagement Stats: Green Search Results: Blue Country Views: Orange Includes headers and neatly formatted tables for each data set. Output: The report can be sent via email using the Gmail API or saved to Google Docs. Example nodes: Gmail node for email delivery. Google Docs node for saving the report as a document. Requirements Prerequisites Google Cloud Setup: Enable Google Analytics API. Enable Gmail API (if using email output). Generate OAuth credentials for API access. n8n Installation: Self-hosted n8n instance with required nodes (Gmail, Google Docs, etc.). Free Cloud-based n8n account. Environment Variables Ensure API credentials and tokens are set up in the n8n environment. Update the respective nodes with client ID, client secret, and access tokens. Configuration Google Analytics Configure the Get Report nodes with the appropriate property ID and metrics. Ensure correct date ranges are selected for each node. Formatting Node The Format Data node processes aggregated data and generates the HTML content. Customize the HTML styling and segment colors as needed. Email Node Configure the Gmail node with OAuth credentials. Set the recipient email address and subject line dynamically. Error Handling Common Issues Authentication Errors: Ensure OAuth credentials are correct. Verify that the APIs are enabled in the Google Cloud Console. Empty Data: Check the raw data from Google Analytics. Validate the property ID and query parameters in the Get Report nodes. Parsing Errors: Ensure the parser nodes are correctly configured and match the expected input format. Debugging Use debug logs in each node to identify data flow issues. Add error-handling nodes to capture and log issues during execution. Example Usage Run the Workflow Trigger the workflow to fetch, process, and format Google Analytics data. Verify Output Check the formatted HTML output in the debug logs. Ensure the email or Google Doc contains the correctly formatted report. Future Enhancements Add support for additional metrics or dimensions. Integrate with Slack for notifications. Enable scheduling for automated reports. Add a visual dashboard for real-time analytics. ---
By Alex KimBackup workflows to git repository on Github
Source code, I maintain this worflow here. Usage Guide This workflow backs up all workflows as JSON files named in the [workflow_name].json format. Steps Create GitHub Repository Skip this step if using an existing repository. Add GitHub Credentials In Credentials, add the GitHub credential for the repository owner. Download and Import Workflow Import this workflow into n8n. Set Global Values In the Globals node, set the following: repo.owner: GitHub username of the repository owner. repo.name: Name of the repository for backups. repo.path: Path to the folder within the repository where workflows will be saved. Configure GitHub Nodes Edit each GitHub node in the workflow to use the added credentials. Workflow Logic Each workflow run handles files based on their status: New Workflow If a workflow is new, create a new file in the repository. Unchanged Workflow If the workflow is unchanged, skip to the next item. Changed Workflow If a workflow has changes, update the corresponding file in the repository. Current Limitations / Needs work Name Change of Workflows If a workflow is renamed or deleted in n8n, the old file remains in the repository. Deleted Workflows Deleted workflows in n8n are not removed from the repository.
By ShashikanthResearch-based article generator with OpenAI and web search for high SEO scores
Generate research-backed article with n8n Who’s it for Content marketers, SEO teams, and founders who need fast, research-grounded blog posts or long-form articles—multi-language included. Works well for teams that want citations, outlines, and section-by-section drafting with minimal manual effort. How it works / What it does Use a Form to collects domain, keywords, and target language. The workflow refines keywords, finds recent articles and authoritative citations, then synthesizes a master outline and loops through each section: generate search queries → fetch web results → summarize findings → write the section with the advanced model. Finally, it aggregates all sections into a clean Markdown article. Optional delivery nodes (Email, Telegram) and an AI Agent are included but disabled by default.&x20; How to set up Import the workflow JSON into n8n. Add your OpenAI credential Set simplemodel / advancedmodel in LLM Params Requirements n8n instance with outbound internet access. OpenAI API access (Responses API + websearchpreview). (Optional) Email/Telegram credentials if you want to deliver results async How to customize the workflow Edit prompts in LLM Params and Section Prompts to match tone, structure, and SEO style Tweak recency and source rules in Search Articles / Search Citations.&x20; Insert a human review step before “Write Section”, enable delivery nodes Change working/output languages in the Language node
By Constantine KisselDigest new YouTube videos to Slack with Google Sheets, RapidAPI & GPT-4o-mini
Who is this for? Marketing, content, and enablement teams that need a quick, human-readable summary of every new video published by the YouTube channels they care about—without leaving Slack. What problem does this workflow solve? Manually checking multiple channels, skimming long videos, and pasting the highlights into Slack wastes time. This template automates the whole loop: detect a fresh upload from your selected channels → pull subtitles → distill the key take-aways with GPT-4o-mini → drop a neatly-formatted digest in Slack. What this workflow does Schedule Trigger fires every 10 min, then grabs a list of YouTube RSS feeds from a Google Sheet. HTTP + XML fetch & parse each feed; only brand-new videos continue. YouTube API fetches title/description, RapidAPI grabs English subtitles. Code nodes build an AI payload; OpenAI returns a JSON summary + article. A formatter turns that JSON into Slack Block Kit, and Slack posts it. Processed links are appended back to the “Video Links” sheet to prevent dupes. Setup Make a copy of this Google Sheet and connect a Google Sheets OAuth2 credential with edit rights. Slack App: create → add chat:write, channels:read, app_mention; enable Event Subscriptions; install and store the Bot OAuth token in an n8n Slack credential. RapidAPI key for https://yt-api.p.rapidapi.com/subtitles (300 free calls/mo) → save as HTTP Header Auth. OpenAI key → save in an OpenAI credential. Add your RSS feed URLs to the “RSS Feed URLs” tab; press Execute Workflow. How to customise Adjust the schedule interval or freshness window in “If newly published”. Swap the OpenAI model or prompt for shorter/longer digests. Point the Slack node at a different channel or DM. Extend the AI payload to include thumbnails or engagement stats. Use-case ideas Product marketing: Instantly brief sales & CS teams when a competitor uploads a feature demo. Internal learning hub: Auto-summarise conference talks and share bullet-point notes with engineers. Social media managers: Get ready-to-post captions and key moments for re-purposing across platforms.
By Naveen ChoudharyPoll emails using JMAP
n8n does not currently offer a way to retrieve emails from arbritrary providers via a regular node. Unless you're using Gmail or Outlook, you can only use the email trigger to start a workflow when a new email arrives. This currently limits the possible use cases you can cover in your n8n workflows, as you cannot (for example) get an idea of how many unread messages there are in an inbox, or search for specific messages when an event occurs. But fear not, there's a new sheriff in town! The JMAP standard allows you to interact with your mailboxes, calendars and contacts through single HTTP requests whenever needed. This n8n workflow demonstrates how to retrieve the total number of unread messages from a JMAP server and also retrieve details for the first 3 messages. It can easily be adapted to search for messages other than unread, or to return details for more than the first 3 messages. Screenshots FAQ Which n8n version do I need? The workflow was built using n8n 1.20 and should work here out of the box. HTTP requests are also supported on older n8n versions, so the workflow can be backported as an alternative. Which credentials do I need? The JMAP standard does not limit the available authentication options. Fastmail (the sponsor of the standard) supports Bearer authentication as well as OAuth2. In n8n you can implement the Fastmail Bearer authentication by creating Header Auth credentials with a name of Authorization and a value of Bearer $apiToken (replacing $apiToken with your actual API token from Fastmail). For other services you'd need to check the respective API documentation for more details on the support authentication methods. What even is JMAP? It's an official Internet Engineering Task Force (IETF) standard, sponsored by Fastmail, that will hopefully replace the legacy standards CalDAV, CardDAV, and IMAP soon. The full specs are available here. How can I use JMAP? If you're a Fastmail customer or if you're hosting your own Stalwart mail server you can use JMAP today. If your email provider doesn't yet support JMAP, you might want to contact them and let them know you're interested in this functionality.
By TomMulti-agent LinkedIn content creation with GPT-4o, Google Sheets, and human review
Description: This is a Production-Grade Multi-Agent Content Engine designed for creators who prioritize technical authority over generic AI output. Unlike standard "one-shot" prompts, this system uses a Chain-of-Thought (CoT) architecture to separate logical blueprinting from creative writing. It features a Persistent Memory loop via Google Sheets to ensure topic variety and a dedicated Compliance Editor to enforce strict branding rules (e.g., "Sentence Case" and spaced hyphens). Built with enterprise resiliency in mind, it includes Global Error Handling and a Human-in-the-Loop Gmail approval gate with a 48-hour auto-timeout. I built this to solve the 'Technical Content' bottleneck. It ensures that my social presence reflects the same high-quality engineering standards I apply to my client's n8n workflows. Key features: Persistent Topic Memory: Automatically scans your Google Sheets history to prevent repeating technical topics. Multi-Agent Pipeline: Specialized agents for Topic Selection, Structural Architecture, Copywriting, and Brand Compliance. Style Enforcement: A final "Editor" agent that strips AI fluff and ensures a professional, human-sounding tone. Resilient Design: Features a global Error Trigger for instant failure notifications and an Approval Timeout to maintain system resources. Human-in-the-Loop: Sends a clean draft to Gmail for manual image pairing and final review before posting. How to setup Google Sheets: Prepare a sheet with columns for Topic, Status, and Difficulty. Credentials: Connect your OpenAI (or Gemini) and Gmail accounts. IDs: Replace the placeholder Sheet ID and Recipient Email address in the nodes. Error Handling: Point the Error Trigger notification to your preferred email or Slack channel.
By Ailin Werner🔐 Double opt-in email verification system with Google Sheets
This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generates unique verification codes, stores them securely, and validates user access before proceeding with your main form. How it Works User submits their email through an initial form System generates a unique 6-digit verification code Code is stored in Google Sheets along with user data Verification email is sent to the user User enters the code to verify their email Upon successful verification, user accesses the main form Setup Follow these steps to configure the workflow: Google Sheets Configuration Create a Google Sheets spreadsheet with the following columns: | Column Name | Data Type | Description | |----------------|-----------|--------------------------------------| | Start Date | String | Timestamp of form submission | | ID | String | Workflow execution ID | | Accepts Terms | String | Terms acceptance flag | | Email | String | User's email address | | Code | String | 6-digit verification code | Google Sheets Connection In n8n, go to Credentials Add new credential for Google Sheets OAuth2 Follow the OAuth2 authorization flow In the workflow, update the "Store Data" node: Replace YOURGOOGLESHEET_ID with your spreadsheet ID Select the correct sheet tab SMTP Configuration Add SMTP credentials in n8n: Go to Credentials > Add new > SMTP Enter your SMTP server details Configure port, username, and password Update the "Send Email" node: Change sender email to your domain Customize subject line and message body Set reply-to address Form Customization Entry Form: Customize the title and privacy policy text Email Form: Update the description for your use case Verification Form: Modify instructions as needed Main Form: Add or modify fields for your requirements Configuration Email Settings From Email: Replace no-reply@yourdomain.com with your sender address Subject: Customize the verification email subject Message: Personalize the email template with your branding Reply-To: Set your support email address Form Messages Update all form descriptions to match your brand voice Customize button labels Modify error messages for better user experience Benefits GDPR Compliance: Ensures legitimate user consent Spam Reduction: Validates email ownership Data Quality: Maintains clean contact lists User Trust: Professional verification process Use Cases Newsletter subscriptions User registration flows Marketing campaign sign-ups Lead generation forms Event registrations Error Handling The workflow includes: Invalid code detection Second attempt opportunity Process restart option after multiple failures Clear error messaging Security Features Unique 6-digit codes for each session Temporary code storage Validation against stored data Multiple attempt limits Tags Double Opt-In, Email Verification, Forms, Google Sheets, GDPR, Data Protection, Email Marketing, Lead Generation Requirements n8n v1.0+ Google Sheets account SMTP server access Basic understanding of n8n workflows Support For questions or issues with this template: Check the sticky notes in the workflow for detailed explanations Review the setup instructions above Ensure all credentials are properly configured Test with a personal email address first Best Practices Test the complete flow before going live Monitor Google Sheets for verification attempts Set up email delivery monitoring Consider implementing code expiration (advanced feature) Keep form messages clear and concise
By Un tal Camilo MedinaExtract meeting to-do lists from audio with Google Gemini and send to Slack
This workflow automates the process of converting audio meeting recordings into a structured to-do list. It listens for new audio files in a Google Drive folder, transcribes them, extracts action items using AI, and sends a formatted list to a designated Slack channel. Who’s it for This template is perfect for project managers, teams, and anyone who wants to save time on post-meeting administrative tasks. If you record your meetings and use Google Drive for storage and Slack for team communication, this workflow will streamline your follow-up process and ensure no action item is missed. What it does This workflow automates the entire process of turning spoken words from a meeting into actionable tasks for your team. Trigger on New Audio: The workflow starts automatically when you upload a new audio file (e.g., MP3, M4A, WAV) to a specific folder in your Google Drive. Transcribe Audio: It takes the audio file and uses Google Gemini to generate a full text transcript of the recording. Extract To-Do Items: The transcript is then passed to another Google Gemini node with a specialized prompt. This prompt instructs the AI to carefully analyze the text and extract all action items. Format Output: The AI formats the extracted tasks into a clean JSON array. Each task includes a description, the assigned person, a deadline, and its priority. Send to Slack: Finally, the workflow sends the structured to-do list as a message to your specified Slack channel, making it easy for the whole team to see and act upon. How to set up Configure Credentials: Ensure you have configured your credentials for Google Drive, Google Gemini, and Slack in n8n. Set Google Drive Folder: In the "Looking for uploading file" node, select the Google Drive folder you want the workflow to monitor. Set Slack Channel: In the "Send a message" node, choose the correct Slack account and select the channel where you want the to-do list to be posted. Activate Workflow: Save your changes and activate the workflow using the toggle at the top right. Test It: Upload a meeting recording to the designated Google Drive folder to see the magic happen! How to customize the workflow Change AI Model: You can easily swap the Google Gemini nodes for other AI models like OpenAI or Anthropic to handle transcription and analysis based on your preference. Modify the AI Prompt: Adjust the prompt in the "Analyze document" node to change the output format. For example, you could ask for a meeting summary in addition to the to-do list. Change Notification Service: Replace the Slack node with another notification service like Discord, Microsoft Teams, or an email node. Archive Results: Add a node (e.g., Google Sheets, Notion, Airtable) after the "Analyze document" node to save a history of all meeting transcripts and their corresponding action items.
By higashiyama Verify generic business emails across multiple domains with EmailListVerify and Google Sheets
Who is this template for? Growth teams and SDR targeting small companies. In small companies, it is common for the founder to monitor the contact@ email, so generic emails can give you good results. What problem does this workflow solve? Get from a list of domain names to a list of email addresses. This workflow allows you to choose which email pattern you are looking for. So you can use it to find function emails like hr@ or accounting@. This is a great way to get in touch with your ICP. What this workflow does Think workflow will: Generate email candidates based on the domain name and root you are providing Check if those email addresses are valid using EmailListVerify Requirement This template uses: Google Sheet to handle input and output data EmailListVerify to discover email (from $0.05 per email) Setup (10 minutes) 1: Make a copy of the GoogleSheet template 2: In "[Input] pattern" sheet, write the root email you want to check, like contact or accounting 3: In "[Input] domain", put the domain for which you want to find email addresses. Write the domain without http or www in front. 4: Add your EmailListVerify API key to setting to the 3rd step 5: Update Google Sheet node to point to your copy of the template 6: Trigger the workflow
By EmailListVerifyGitHub bounty issue tracker & alert system (Google Sheets + Email/WhatsApp)
GitHub Bounty Issue Tracker & Alert System (Google Sheets + Email/WhatsApp) Overview Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google Sheets, and sends instant alerts via Email (HTML-styled) or WhatsApp. Perfect for developers, freelancers, and open-source contributors who want to discover and claim paid opportunities faster. --- What This Workflow Does 🔎 Automated Bounty Discovery Searches GitHub hourly for all open issues labeled with “💎 Bounty.” Filters duplicates to avoid re-tracking the same issue. 📢 Smart Notifications Sends styled HTML email alerts with GitHub-themed design. WhatsApp Business API integration (optional, disabled by default). Alerts only for bounties created within the last 5 days. 📊 Google Sheets Tracking Sheet1: Complete bounty list (all tracked issues). Sheet2: Recent notification log (for quick reference). 🔄 Status Updates Checks every 6 hours for issue changes (open/closed state, new comments). Includes bounty amount, issue details, and direct GitHub links. --- Use Cases 👩💻 Freelance developers hunting for paid open-source work. 🛠 Development teams tracking bounty opportunities for their stack. 🌍 Community managers monitoring open-source bounty program engagement. 🤝 Open-source contributors looking for compensated tasks. --- Requirements GitHub Personal Access Token (with repo access). Google Sheets (2 sheets required: Sheet1 = bounties, Sheet2 = notifications). Gmail account (OAuth2 for sending email alerts). WhatsApp Business API credentials (optional). --- Configuration Notes This workflow supports pagination for large result sets and includes filters to prevent duplicate notifications. You can customize the GitHub search query in the HTTP Request node to target: Specific repositories Custom labels Team/organization projects --- Frequently Asked Questions (FAQ) Q: How often will I get notifications? A: By default, new bounties trigger alerts once an hour. Updates on existing issues (status/comments) are checked every 6 hours. Q: Do I need WhatsApp integration? A: No, it’s optional. Email alerts work out-of-the-box. Q: Can I filter by bounty amount? A: Yes, the workflow extracts bounty details and you can add filters in your Google Sheets or notification logic. --- Why Use This GitHub Bounty Tracker? Unlike manual searches, this workflow ensures you never miss a paid GitHub issue. Whether you’re a freelancer looking for income, a team seeking funded tasks, or a contributor wanting recognition and rewards, this system keeps you updated automatically.
By Jeffrey W.Evaluate interview & update scores with Azure GPT-4o-mini and Google Sheets
Description Automatically score candidate questionnaire responses using Azure OpenAI (GPT-4o-mini), combine them with existing evaluations from Google Sheets, and keep your candidate database up to date—all in near real time. Get consistent, structured scores and key takeaways for faster, fairer decisions. ⚡📊 What This Template Does Monitors new questionnaire submissions in Google Sheets every minute. ⏱️ Evaluates responses with Azure OpenAI and returns structured JSON (score + takeaways). 🤖 Parses model output safely and normalizes fields. 🧩 Retrieves existing candidate data from a central Google Sheet. 📂 Calculates combined final scores and updates/append records by candidate name. ➕ Key Benefits Consistent, objective scoring across all responses. 🎯 Real-time processing from form submission to database update. 🚀 Clear JSON outputs for downstream reporting and analytics. 📈 No-code customization of questions, weights, and fields. 🛠 Scales effortlessly with high submission volumes. 📥 Features Continuous polling of the “BD Questionarie” → “Form Responses 1” sheet. 🔄 AI evaluation with GPT-4o-mini returning score (0–30) and takeaways. 🧠 Resilient JSON parsing (handles code fences and errors). 🧼 Candidate lookup in “Resume store” → “Sheet2” for data fusion. 🔗 Additive scoring model: Final Score = Existing Score + Questionnaire Score. ➕ Append or update records by name while preserving existing data. 📝 Requirements n8n instance (Cloud or self-hosted). 🌐 Google Sheets access: “BD Questionarie” spreadsheet (sheet: “Form Responses 1”) for new responses. “Resume store” spreadsheet (sheet: “Sheet2”) for existing profiles. Credentials configured in n8n (OAuth/Service Account) with read/write where needed. 🔐 Azure OpenAI access with a GPT-4o-mini deployment for evaluation and JSON output. 🤖 Ability to customize evaluation questions and scoring weights within the workflow. ⚙️ Target Audience Teams evaluating candidate questionnaires and consolidating scores. 👥 Operations teams centralizing hiring data in Google Sheets. 🗂️ Organizations seeking real-time, AI-assisted screening. 🧭 No-code/low-code builders standardizing hiring workflows. 🧱 Step-by-Step Setup Instructions Connect Google Sheets in n8n Credentials; grant access to “BD Questionarie” and “Resume store.” 🔑 Add Azure OpenAI credentials in n8n; ensure a GPT-4o-mini deployment is available. 🤝 Import the workflow, assign credentials to each node, and set the sheet IDs/ranges. 📋 Confirm name is the matching key, and adjust evaluation weights or questions as needed. ⚖ Run once to validate parsing and score calculation, then enable polling (every minute). ▶️
By Rahul JoshiWhatsApp support assistant with GPT-4 Mini & Google Sheets data training
WhatsApp AI HelpDesk – Smart SupportBot Using Trained Data & WasenderAPI Overview This n8n workflow enables automated AI-driven support replies via your personal WhatsApp number using WasenderAPI.com. The bot intelligently responds to user messages based on trained data stored in Google Sheets, helping you avoid the high cost of WhatsApp Business API. --- What It Does Reads real-time data from a connected Google Sheet Sends AI-generated responses based on predefined training data Automatically applies rate limits to avoid account blocking Updates each contact's support status after responding --- Who’s It For This workflow is ideal for: Freelancers and small businesses offering support through WhatsApp Customer service teams seeking to automate common queries Entrepreneurs looking to deploy a cost-effective support assistant SaaS founders managing WhatsApp inquiries without expensive API costs --- Prerequisites Make sure the following components are ready: An active WhatsApp account (Personal or Business) WasenderAPI subscription (around $6/month) OpenAI API access (around $20/month) n8n instance (self-hosted or cloud) Google Sheets API connected to n8n A training sheet like this sample: https://docs.google.com/spreadsheets/d/1Ui4TzzI-Gq-bsEsrZELwW1Kyddw0IU9L1wxlHikktqw/edit?usp=sharing --- Setup Instructions Connect WasenderAPI Add your WhatsApp session to WasenderAPI In n8n, create a Webhook node Copy the webhook URL and paste it into your WasenderAPI session settings Connect OpenAI Add an OpenAI node in n8n Authenticate using your OpenAI credentials Configure the prompt to reference the data from your Google Sheet Connect Google Sheets Add a Google Sheets node Authenticate using your Google account Select the appropriate Spreadsheet and Worksheet Format your sheet similarly to the sample template above --- How to Customize the Workflow To tailor the workflow to your business needs: Update the training data in your Google Sheet to include your own FAQs, product info, or customer scripts Adjust prompt instructions in the OpenAI node to change the tone, style, or behavior of the response Add filtering logic using IF or SWITCH nodes to categorize and route different types of messages Integrate CRM or ticketing systems via additional HTTP or database nodes Set custom response delay or batching using WAIT or LIMIT nodes to control the load --- Support & Community Need help setting up or customizing the workflow? Reach out here: WhatsApp: Chat with Support Discord: Join SpaGreen Server Facebook Group: SpaGreen Community Website: SpaGreen Creative Envato: SpaGreen Portfolio
By SpaGreen Creative