Data & Analytics Workflows
Data processing and analytics
Automate Facebook Ads Insights to PostgreSQL Database
Effortlessly transfer Facebook Ad Account insights into your PostgreSQL database for streamlined advertising analysis and reporting.
MakeFreeOTX & OpenAI Automated Web Security Audit
Automates website security checks using AlienVault OTX threat intel, OpenAI AI analysis, and email reports. Ideal for quick vulnerability audits via simple URL input.
n8n$22.99Automate JSON Array Import to Firestore
This workflow automates the import of a JSON array into a Firestore collection, allowing for periodic execution to keep your database up-to-date.
Make$3.99Automate Notion Database Updates via Custom Webhook
Streamline your workflow by automatically updating Notion database items using a custom webhook. This integration ensures seamless data synchronization between your systems and Notion.
Make$2.99Automate Phantombuster Results Import to Google Sheets
Effortlessly transfer the latest Phantombuster phantom results into Google Sheets for streamlined data management.
Make$4.99Automate API Data Retrieval and Google Sheets Entry
Effortlessly fetch data from an API and insert it as a new row in Google Sheets, enhancing data management efficiency.
Make$3.99Automatically Insert New WordPress Posts into PostgreSQL
Streamline your data management by automatically adding new WordPress posts as rows in your PostgreSQL database.
MakeFreeVerify emails in new files in Dropbox using Email List Verify
Every time you add a new file containing emails (CSV, DOCX) in a specified folder in Dropbox, Make will automatically upload that file to Email List Verify, which will add the column containing statuses for each email, and then it will be uploaded back to Dropbox.
Make$4.99Automated Stripe Payment Recovery: Track Failures & Follow-Up Emails
Detects failed Stripe payments, logs details in Google Sheets, and sends tiered follow-up emails daily to recover lost revenue effortlessly.
n8n$19.99Retrieve User First and Last Names via Facebook Graph API
This workflow retrieves the first and last names of a user from the Facebook Graph API, providing a simple way to access user information.
n8nFreeGA4 Anomaly Detection with Automated Slack & Email Alerts
## Who's it for Teams that monitor traffic, signups, or conversions in Google Analytics 4 and want automatic Slack/email alerts when a channel suddenly spikes or drops. ## What it does This n8n template pulls daily GA4 metrics, detects outliers with a rolling mean and z-score, and sends alerts with a sparkline chart. It supports per-channel analysis (e.g., `sessionDefaultChannelGroup`) and consolidates multiple anomalies into a single email while posting each one to Slack. ## How it works - **HTTP Request (GA4 Data API)** fetches `sessions`, `newUsers`, `conversions`, `bounceRate` by `date` + channel. - **Code** calculates 7-day moving average and z-scores, flags anomalies, and builds QuickChart links. - **If** filters on `alert === true` and optional `ALERT_ME` toggle. - **Slack** posts an alert + chart. - **Email** sends one summary email (subject + HTML table + charts). ## Requirements - GA4 OAuth2 credential in n8n. - Slack API credential (bot with chat:write). - Email credential (SMTP or service). - GA4 property ID and at least several recent days of data. ## Where to find your GA4 Property ID - **In the GA UI:** 1. Open **Google Analytics** → bottom-left **Admin** (gear). 2. In the **Property** column, click **Property settings**. 3. Copy **Property ID** - it's a **numeric** value (e.g., `481356553`). - **From the URL (quick way):** When you're inside the GA4 property, the URL looks like: `/analytics/web/#/p123456789/` → the digits after **`p`** are your **Property ID** (`123456789` in this example). - **What *not* to use:** - **Measurement ID** (looks like `G-XXXXXXX`) - that's the data stream ID, **not** the property ID. - **Universal Analytics IDs** (`UA-XXXXX-Y`) - those are legacy and won't work with GA4 Data API. - **In this template:** Put that numeric ID into the **Set → `PROPERTY_ID`** field. The HTTP node path `properties/{{ $json.PROPERTY_ID }}:runReport` expects **only the number**, no prefixes. ## How to set up 1. Open the **Set (Define variables)** node and fill: `PROPERTY_ID`, `LOOKBACK_DAYS`, `ALERT_PC`, `Z_THRESHOLD`, `CHANNEL_DIM`, `ALERT_ME`. 2. Connect your **Google Analytics OAuth2**, **Slack**, and **Email** credentials. 3. In **Email Send**, map `Subject` → `{{$json.emailSubject}}` and **HTML** body → `{{$json.emailHtml}}`. Keep **Execute once** enabled. 4. Run the workflow. ## How to customize - Change the moving-average window (`WINDOW/MA_WINDOW`) and chart range (`LAST_N_DAYS_CHART`). - Swap `CHANNEL_DIM` (e.g., source/medium) to analyze different dimensions. - Add/remove metrics in the GA4 request and the metrics list in the Code node. - Tweak thresholds to reduce noise: raise `Z_THRESHOLD` or `ALERT_PC`. ## Output example 
n8n$9.99Automate Notion to Google Sheets Data Transfer
Automatically transfer new items from a Notion database to Google Sheets for streamlined data organization and accessibility.
MakeFreeAutomate Data Synchronization from Google Sheets to PostgreSQL
Effortlessly synchronize data from Google Sheets to your PostgreSQL database. This workflow ensures data consistency by automating the retrieval, comparison, and updating of datasets.
n8n$9.99Automate Contact Updates from Dux-Soup to Google Sheets
Automatically create or update contact entries in Google Sheets when new data is received from Dux-Soup via a webhook.
Make$3.99Seamlessly Transfer Wealthbox Contacts to Google Sheets
Effortlessly export Wealthbox Person contacts, including first name, last name, and email, to Google Sheets. This workflow supports up to 3200 records, ensuring efficient data management.
Make$2.99Verify email addresses stored in Microsoft 365 Excel worksheet in Hunter
This template allows you to do a Hunter email verification from a new row in your Microsoft 365 Excel worksheet. The worksheet is then updated with the status of the email. Your Microsoft 365 Excel worksheet has to contain headers. The template uses [this worksheet](https://1drv.ms/x/s!AjJKBs6vWrtygSH_kVhXjXbCV98Q?e=qwG4S).
Make$3.99Add new rows to Google BigQuery from a custom webhook
Streamline your data management process by automatically adding new entries to Google BigQuery whenever a custom webhook is triggered. This template allows you to efficiently capture and store data from various sources, ensuring that your analytics and reporting are always up-to-date. Perfect for developers and data analysts looking to enhance their data workflows without manual intervention.
Make$2.99Integrate Typeform Data into Pinecone for Enhanced Search and Organization
Automatically upsert vectors into a Pinecone namespace using new data from Typeform, enhancing your database's search capabilities and organization.
MakeFreeGet Ranked Keywords for new Airtable records
Every time a new record is created in Airtable, this template will use the DataForSEO API, and instantly pull ranked keywords for the target domain indicated in the record. The input table is expected to have these columns: arget, Location and Language.
Make$4.99Verify emails in a Google Sheets spreadsheet using Hunter
Every time a new row added to a specified Google Sheets spreadsheet, Make will automatically check the email containing in this record using Hunter and update a row with information about validity of the email. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1VlaaXQfkNj2x3SAnvwi2z7FAZ_JQhUwNPLfKIUOXM/edit?usp=sharing).
Make$3.99Add Google Sheets rows for new Weavely responses
Add a new row in Google Sheets whenever a form is submitted in Weavely.ai. This template makes it easy to collect responses in a spreadsheet for tracking, reporting, or sharing with your team. This template was created by Weavely.ai. For questions or support, visit [weavely.ai](https://www.weavely.ai/)
Make$2.99Automatically Log New RSS Feed Items as Beeminder Datapoints
This workflow automatically creates a datapoint in Beeminder for each new item posted to a specified RSS feed, helping you track and quantify your reading habits or content consumption.
Make$2.99Automate WooCommerce Data Transfer to External Applications
Efficiently automate the transfer of WooCommerce event data to external applications using HTTP requests, enhancing data integration and workflow efficiency.
Make$2.99Sync Microsoft SQL Server Data to Google Sheets
Automatically transfer selected rows from a Microsoft SQL Server database table to a Google Sheets spreadsheet, ensuring your data is always up-to-date and accessible.
Make$2.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work