Data & Analytics Workflows
Data processing and analytics
Seamlessly Transfer Mailjet Contacts to Google Sheets
Automatically export up to 3200 Mailjet contacts into a Google Sheets document, ensuring your contact data is organized and accessible.
MakeFreeAutomate Airtable Record Search and Upsert for Streamlined Data Management
Enhance your data management by automating the search and upsert of records in Airtable. This workflow ensures your Airtable database is always up-to-date by leveraging the Search Records and Upsert a Record modules.
Make$2.99Automate Data Sync from Cognito Forms to Ninox
Effortlessly keep your Ninox database updated by automatically syncing new entries from Cognito Forms. This workflow ensures your records are always current, allowing you to focus on business growth.
Make$2.99Automate Data Insertion into PostgreSQL and Firestore from Browse AI Tasks
Streamline your data management by automatically inserting data into PostgreSQL and creating documents in Google Cloud Firestore from completed Browse AI tasks.
Make$3.99Automate Record Search and Deletion in Datastore
Efficiently manage your datastore by automating the search and deletion of records. This workflow streamlines data maintenance tasks.
MakeFreeStructured Data Extract & Mining with Bright Data & Google Gemini
Automates extraction of structured data from web content using Bright Data scraping and Google Gemini AI for topic mining, summarization, and trend analysis.
n8n$24.99Automated Sitemap Link Extraction and Google Sheets Integration
This workflow extracts sitemap links using the ScrapingBee API and appends them to a Google Sheet. It recursively processes new XML links found during sitemap scraping.
n8n$14.99Automate GitHub Releases via Telegram Bot Command
Trigger GitHub version releases directly from Telegram bot commands like '/deploy v1.0'. Ideal for streamlined CI/CD pipelines without complex setups.
n8n$9.99Streamline JotForm Submissions to Google Sheets
Automatically transfer JotForm submissions to Google Sheets for efficient data management and analysis.
n8n$9.99Automate File Conversion to JSON with ParquetReader API
Effortlessly convert Parquet, Feather, ORC, and Avro files to JSON format using the ParquetReader API. This workflow simplifies data inspection and validation without the need for custom code.
n8n$4.99Automate Google Forms Responses to EasyCSV via Dropbox
Automatically capture new Google Forms responses, convert them into a CSV file, store it in Dropbox, and import it into EasyCSV for seamless data management.
Make$4.99Insert Data into a New Row for a Table in Coda
Unfortunately, I can't view images or files, so I'm unable to directly correct the description from the screenshot you mentioned. However, if you can provide the text from the description, I'd be happy to help correct it!
n8n$3.99AI Chatbot Call Center: Production-Ready Demo (Part 2)
Production-ready n8n workflow serving as the main entry for a multi-service AI chatbot call center, routing incoming calls to chit-chat AI or specialized services like taxi booking with rate limiting and scaling.
n8n$24.99Automatically Export SQL Data to Excel Spreadsheet
Effortlessly convert SQL query results into Excel spreadsheets for easy data management and sharing.
n8n$4.99Automate Expense Receipt Processing to Google Sheets
Streamline your expense tracking by automatically extracting data from receipt photos and adding it to Google Sheets using Telegram, Mindee API, and Twilio.
n8n$4.99Onfleet Driver Signup Notifications in Slack
This workflow triggers on new Onfleet driver signups and sends instant notifications to a Slack channel, keeping your team informed effortlessly.
n8n$4.99Automate Data Transfer and Record Updates in Datastore
Efficiently manage your data by automating the transfer and updating of records in your datastore using HTTP actions. Enhance productivity with seamless data integration.
Make$3.99Filtering and Branching Data
**Ask:** Conditional filtering and branching items **Why:** Filtering and branching data based on conditions allows you to build complex workflows that work with more than one data flow scenario. **Main use cases:** - Filter out data that is not relevant for the rest of the workflow. - Split data into several branches of the workflow, where we want the data to be treated differently in the rest of the workflow.
n8n$9.99Export SQL Data to XML with XSL Formatting via Webhook
This workflow exports SQL data to XML and formats it using an XSL template, ensuring compatibility with modern browser CORS policies.
n8n$9.99Automate Data Transfer Between JSON, Google Sheets, and CSV Files
This workflow automates the process of fetching JSON data, converting it to various formats, and importing it into Google Sheets or local CSV files. It also demonstrates how to send JSON data via email.
n8n$9.99Automatically Sync Google Sheets Rows to Ninox for Seamless Record Management
Effortlessly keep your Ninox database up-to-date by automatically syncing new or modified rows from Google Sheets. This workflow ensures your records are always current, enhancing project management and collaboration.
Make$2.99Real-Time Processing of Icypeas Search Results with n8n
This workflow enables real-time listening and processing of search results from Icypeas using n8n. It integrates with a webhook to capture search data and a set node to extract relevant information, such as email and names.
n8n$4.99JSON Data Utility: Extract Key-Value Pairs by Index
## Extract a key-value pair by index from JSON to fields in n8n This template takes a JSON object and a **row index** and returns exactly one **key-value pair** at that index. It's a handy helper when you only need a single entry from a structured JSON payload (e.g., picking one form field for downstream logic). ## Who's it for - Makers who want a quick **JSON picker** without writing full parsing logic. - Developers testing API payloads or building **proofs of concept**. - Ops/analysts who need to **pluck a single field** for emails, documents, or notifications. ## How it works 1. **Manual Trigger** (`When clicking ‘Test workflow’`) starts the flow. 2. **Set ‘Input JSON Node’** holds your sample payload with: - `myData`: an object of key-value pairs. - `rowIndex`: a 0-based index indicating which pair to extract. 3. **Code (Python) ‘Find Key-Value Pair’** iterates `myData` and returns `[key, value]` at `rowIndex` as `result`. 4. **Set ‘Key’** maps `result[0]` to a field named `result`. 5. **Set ‘Value’** maps `result[1]` to a field named `result[1]`. 6. The selected **key** and **value** are then available to any downstream nodes. ## How to set up 1. Open the workflow and select **Input JSON Node**. 2. Replace the sample with your own JSON: ```json { "myData": { "name": "Alice", "age": 30, "city": "Paris" }, "rowIndex": 1 } ``` 3. Click **Execute Workflow**. Check the **Key** and **Value** nodes for the outputs. ## Requirements - n8n running (cloud or self-hosted). - **Code node (Python)** enabled in your n8n version. - Input payload structure: - `myData`: object with keys/values - `rowIndex`: integer (0-based) ## How to customize - **Pick by key name** (instead of index): adjust the Python code to look up a specific key. - **Handle nested objects/arrays**: walk or flatten the structure before selecting. - **Change output shape**: return `{ "key": ..., "value": ... }` or write directly to next-node fields. - **Validate inputs**: add checks for out-of-range `rowIndex`, non-object `myData`, or empty objects. ## Add-ons - **Webhook intake**: Replace Manual Trigger with a Webhook to accept live JSON. - **Schema guard**: Add an If/Function step to ensure `myData` is an object and `rowIndex` is numeric. - **Audit log**: Append the selected key/value to Google Sheets or a database. ## Use Case Examples - Pull one field from a large API response to include in an **email**. - Extract a specific answer from a **form submission** for conditional routing. - Read a configuration pair from a **settings object** to control a downstream step. ## Common troubleshooting | Issue | Possible Cause | Solution | |---|---|---| | “Index out of range” | `rowIndex` is larger than the number of keys | Use a valid 0-based index; add a guard in the Code node to clamp or default. | | Wrong key returned | Object key **order** differs from expectations | Object key order isn't guaranteed across sources—prefer **pick by key name** for reliability. | | Empty/invalid output | `myData` is not an object or is empty | Ensure `myData` is a flat object with at least one key. | | Python errors | Code node's Python runtime not available | Enable Python in the Code node or convert the snippet to JavaScript. | | Value type mismatch | Value isn't a string | Cast as needed in the Set node or normalize types in the Code node. | ## Need Help? If you'd like this to **pick by key**, handle **nested JSON**, accept data via **Webhook** or fully customized to your needs, write to us and we'll adapt the template to your exact use case.
n8n$4.99Seamlessly Migrate Data from Airtable to PostgreSQL Using n8n
Automate the migration of data from Airtable to PostgreSQL, ensuring schema compatibility and data integrity with n8n.
n8n$19.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