Data & Analytics Workflows
Data processing and analytics
Generate Random Mock Data with No Code and Zero Dependencies
## Random Data Generator This beginner-friendly workflow allows you to generate random mock data effortlessly, without any programming or external dependencies. Here's how it works: 1. Provide some default values for the random generator using the Code node. Don't worry, no coding is needed, it's just a simple JSON! You can even use the Ask AI in the cloud version of n8n to generate mock values for you. These values are permanently stored in the workflow ensuring swift and reliable execution. 2. The Firstname, Lastname, and Occupation nodes extract individual variables. Two Merge nodes create a combination of all possible values. Adapt this section based on your needs. 3. The Random node shuffles the generated data. 4. Use the Limit node to control the number of output items. 5. Perform additional post-processing, such as deriving email addresses based on the user's name and surname. And there you have it! With just a few clicks, you'll have a set of realistic mock data ready to test your workflows. Want to learn more? Check out the full tutorial on YouTube! [](https://www.youtube.com/watch?v=3AVJFk3uXBg) Happy data generating!
n8n$9.99Send Mattermost Notification on n8n Startup
Automatically sends a Mattermost message with timestamp whenever your n8n instance starts or restarts.
n8n$4.99Automate Apify Dataset Transfers to Google Sheets
Seamlessly transfer Apify dataset items to Google Sheets upon actor run completion, optimizing data management and workflow efficiency.
Make$3.99Automate Webhook Data Management in Google Sheets with Email Alerts
Automatically process incoming webhook data by updating or adding entries in a Google Sheet and sending email notifications.
Make$3.99Run Apache Airflow DAG and Retrieve XCom Value
# Run Apache Airflow DAG and Retrieve XCom Value ## What this workflow does This workflow integrates the Apache Airflow API [DAGRun](https://airflow.apache.org/docs/apache-airflow/2.10.5/stable-rest-api-ref.html#tag/DAGRun) and [XCom](https://airflow.apache.org/docs/apache-airflow/2.10.5/stable-rest-api-ref.html#tag/XCom). It enables n8n to trigger Airflow DAGs and retrieve the execution results. ## Preparation: 1. **Update Airflow API Link Prefix** - Navigate to the `airflow-api` node. - Update the prefix of the Airflow API link in the format: `http(s)://ip:port`. - Example: `https://airflow.example.com` 2. **Configure Authentication** - Go to the `Airflow: dag_run` node. - Update the `Basic Auth` credentials with your Airflow username and password. - Repeat this step for `Airflow: dag_run - state` and `Airflow: dag_run - get result` nodes. **Security Note:** Using Basic Authentication requires storing credentials in plaintext. If possible, consider using API Keys or tokens for enhanced security. - An example is setting Airflow's [API Authentication](https://airflow.apache.org/docs/apache-airflow-providers-fab/stable/auth-manager/api-authentication.html) to [basic_auth](https://airflow.apache.org/docs/apache-airflow-providers-fab/stable/auth-manager/api-authentication.html#basic-authentication). Choose other authentication methods if needed. - Ensure the user account has the following permissions: `can create on DAG Runs`, `can read on DAG Runs`, `can read on XComs`, `can edit on DAGs`, and `can read on DAGs`. ## How to Use: To execute this workflow, use the **Execute Sub-workflow** node with the following input parameters: - **dag_id**: The DAG ID (name) in Airflow that you want to trigger. - **task_id**: The task ID (name) from which you want to retrieve the XCom return_value. - **conf**: Input data for the Airflow DAG run. - **wait**: Delay (in seconds) between each `Airflow: dag_run - state` check. - **wait_time**: The maximum time (in seconds) to wait for `Airflow: dag_run - state` before returning an error. ## Output: - The workflow returns the XCom result from `Airflow: dag_run - get result`. - The XCom `return_value` is stored in the `value` field.
n8n$9.99Get 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.99Automated Daily n8n Workflow Backup to GitHub
Automatically backs up all n8n workflows to GitHub daily via n8n and GitHub APIs, ensuring version control, updates, and disaster recovery.
n8n$19.99Automatically Retrieve Google SERP Positions for New Airtable Records
This workflow automatically fetches Google SERP positions for keywords in new Airtable records using the DataForSEO API, updating the records with the retrieved data.
Make$3.99Competitor Price Monitoring: Web Scraping, Sheets & Discord Alerts
Automates daily scraping of competitor prices from websites like BooksToScrape, compares against Google Sheets data, and sends Discord alerts for price drops.
n8n$12.99Automate Keyword Extraction from Google Form Responses to Airtable Using Eden AI
Streamline your workflow by automatically extracting keywords from Google Form responses and storing them in Airtable using Eden AI.
Make$3.99Identify and Document AI Models in n8n Workflows
Automatically fetch and analyze workflows in your n8n instance to identify AI models used, and document the findings in Google Sheets.
n8n$9.99Automated Airtable to Postgres Data Migration
Automates ETL migration from Airtable to PostgreSQL via API, with schema mapping, table creation, and batch data transfer while preserving relationships.
n8n$24.99Automate ParseHub Data Extraction and Storage in GitHub
Automatically retrieve, convert, and store ParseHub project data in a GitHub repository at regular intervals.
Make$4.99Weekly GSC SEO Pulse: Brand vs Non-Brand Performance
Automates weekly Google Search Console reports comparing brand and non-brand organic metrics like clicks, impressions, CTR, and position with WoW % changes, sent via email.
n8n$16.99Automatically Insert WordPress Comments into PostgreSQL
Effortlessly transfer new WordPress comments into your PostgreSQL database, ensuring your data is always up-to-date.
MakeFreeAutomate Connection Migration Across Multiple Scenarios
Efficiently migrate connections across multiple scenarios in Make without manual edits, streamlining your workflow management.
Make$4.99Automate Brand Mention Tracking and Reporting with DataForSEO and Slack
This workflow automatically tracks daily brand mentions using the DataForSEO API, compiles detailed reports in Google Docs, and sends updates via Slack.
Make$4.99Using the Merge Node - Merge by Key
This is an example of how you can make Merge by Key work. The "Data 1" and "Data 2" nodes simply provide mock data. You can replace them with your own data sources. Then the "Convert Data" nodes are important. They make sure that the different array items are actually different items in n8n. After that, you have the merge with the merged data.
n8n$4.99Synchronize Airtable with Cloudinary Uploads
Automatically update Airtable records when new resources are uploaded to Cloudinary, ensuring your data stays current and synchronized.
Make$3.99Automate Weekly Google Analytics Data Sync to Google Sheets
Effortlessly keep your Google Sheets updated with the latest user and session statistics from Google Analytics every Friday at 17:00. Customize the schedule to ensure stakeholders have access to the most current website metrics.
Make$2.99Discover Hidden YouTube Trends & Outlier Videos in Your Niche
Automates weekly scraping of YouTube videos for niche keywords using Apify, summarizes scripts with AI, and stores data in Airtable to uncover hidden trends and outliers.
n8n$24.99Automate Google Ads Metrics Retrieval to Google Sheets
This workflow automates the process of retrieving Google Ads keyword metrics via the DataForSEO API and updates them in Google Sheets. Customize the schedule to fit your needs and ensure your spreadsheet is structured with the necessary columns for seamless data integration.
Make$4.99Automate CommCare Form Data Entry into Google Sheets
Automatically transfer new CommCare form submissions into Google Sheets, streamlining data management and accessibility.
MakeFreeAutomate RSS Feed Conversion to Google Sheets
Effortlessly convert new RSS feed articles from HTML to text and store them in Google Sheets for streamlined management and tracking.
Make$3.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