Data & Analytics Workflows
Data processing and analytics
Update Notion database items based on changes in Google Sheets rows
Automatically update Notion database items when changes occur in Google Sheets rows, ensuring your data stays synchronized across both platforms effortlessly.
Make$3.99AI Social Media Caption Creator for Airtable
Automates AI-generated social media captions in Airtable using briefings, target group info, and tonality for consistent, high-quality posts.
n8n$12.99Automate Google Sheets Updates with ActiveCampaign Data
Efficiently manage and update Google Sheets by integrating ActiveCampaign campaign data, streamlining your data management process.
Make$3.99Automate LinkedIn Ads Data Export to Excel 365
Automatically download and organize yesterday's LinkedIn Ads performance data into a Microsoft Excel 365 workbook every day at 8 AM.
MakeFreeAutomate Sales Cold Calling Pipeline with Apify, GPT-4o & WhatsApp
Automates end-to-end cold calling by scraping prospects with Apify, generating personalized messages via GPT-4o and RAG, and delivering via WhatsApp for scalable outreach.
n8n$24.99Automate Data Monitoring and Task Execution with Google Sheets and Browse AI
This workflow monitors Google Sheets for new or updated rows and triggers tasks in Browse AI, enabling seamless automation of data-driven processes.
MakeFreeGmail Unwanted Email Bulk Cleaner
Manually triggered workflow that searches Gmail for unwanted emails (e.g., chats, unsubscribe, license notices) and bulk deletes them in batches of 100 for efficient inbox cleanup.
n8n$9.99Sync New HubSpot Contacts to Google Sheets Instantly
Effortlessly synchronize new HubSpot contacts to Google Sheets, keeping your contact data organized and ready for analysis.
MakeFreeAutomate ParseHub Data Export to Google Sheets in Drive
This workflow automates the process of retrieving data from a ParseHub project, converting it to a Google Sheets-compatible format, and saving it in Google Drive.
Make$4.99Automatically Sync Google My Business Reviews to Google Sheets
Effortlessly transfer new Google My Business reviews to Google Sheets for streamlined data management and analysis.
MakeFreeAutomate Apify Task Execution and Google Sheets Updates
Efficiently automate the execution of Apify tasks and seamlessly update Google Sheets with the results. Enhance your data processing workflow for real-time insights.
Make$3.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.99Send new data from Google Sheets to Facebook Conversions API
When a new row is created in Google Sheets spreadsheet, the data from the row are sent to Facebook Conversions API.
MakeFreeAutomate Google Sheets Data Transformation and Upload to AWS S3
Efficiently filter data from Google Sheets, convert it to XML, and upload it to AWS S3 for streamlined data management.
Make$4.99CommonJS Package Data Processor
Automates processing of package.json files to detect and handle CommonJS module types in data workflows. Ideal for Node.js project analytics and compatibility checks.
n8n$4.99Automatically Log Google Cloud Pub/Sub Messages to Google Sheets
Capture and store every new message from Google Cloud Pub/Sub directly into Google Sheets for streamlined data management.
MakeFreeAutomate Backlink Data Transfer from SE Ranking to Google Sheets
Streamline your SEO analysis by automatically transferring backlink data from SE Ranking into Google Sheets for easy tracking and management.
MakeFreeSend data from a custom webhook to Google Sheets and respond with JSON
Automatically send data from a custom webhook to Google Sheets, then respond with JSON. Streamline data management and enhance response efficiency.
Make$4.99OpenAI Assistant with Custom n8n Tool Integration
Chat-based OpenAI Assistant that calls custom n8n workflows as tools for data access, extending AI capabilities to any data source.
n8n$14.99Comprehensive Email Header Analysis for IP and Spoofing Detection
This n8n workflow analyzes email headers to detect IP addresses and assess potential spoofing risks. It evaluates IPs using the IP Quality Score and IP-API, and verifies email authentication through SPF, DKIM, and DMARC checks.
n8n$24.99Enrich Up to 1500 Emails per Hour with Dropcontact Batch Requests
The template allows making Dropcontact batch requests up to 250 requests every 10 minutes (1500/hour). Valuable if high volume email enrichment is expected. Dropcontact will look for email & basic email qualification if first_name, last_name, company_name is provided. --- **Step 1: Node Profiles Query** Connect your own source (Airtable, Google Sheets, Supabase,...); the template is using Postgres by default. **Note I:** Be careful your source is only returning a maximum of 250 items. **Note II:** The next node uses the following variables, make sure you can map these from your source file: - first_name - last_name - website (company_name would work too) - full_name (see note) **Note III:** This template is using the Dropcontact Batch API, which works in a POST & GET setup. Not a GET request only to retrieve data, as Dropcontact needs to process the batch data load properly. --- **Step 2: Node Data Transformation** Will transform the input variables into the proper JSON format. This JSON format is expected from the Dropcontact API to make a batch request. full_name is being used as a custom identifier to update the returned email to the proper contact in your source database. To make things easy, use a unique identifier in the full_name variable. --- **Step 3: Node: Bulk Dropcontact Requests.** Enter your Dropcontact credentials in the node: Bulk Dropcontact Requests. --- **Step 4: Connect your output source by mapping the data you like to use.** --- **Step 5: Node: Slack (OPTIONAL)** Connect your Slack account, if an error occurs, you will be notified. **TIP:** Try to run the workflow with a batch of 10 (not 250) as it might need to run initially before you will be able to map the data to your final destination. Once the data fields are properly mapped, adjust back to 250.
n8n$9.99Automate Bulk Email Verification with Icypeas and Google Sheets
Streamline your email verification process by automatically searching and verifying email addresses using Icypeas, with data sourced from Google Sheets.
n8n$4.99Export Wild Apricot registrations into Google sheet
This Make workflow exports new Wild Apricot event registrations into a Google Sheet automatically. When a registration occurs, the trigger captures the attendee details and sends them to a specified sheet, keeping your records current without manual entry. Ideal for nonprofit
Make$9.99Automate Weather Data Visualization and Delivery via Telegram Bot
This workflow automates the process of fetching weather data for European capitals, visualizing it using R's ggplot2, and delivering the resulting image to users via a Telegram bot.
n8n$14.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