Data & Analytics Workflows
Data processing and analytics
Log Mailgun Email Opens to Google Sheets Automatically
Automatically track and log email opens from Mailgun into Google Sheets, capturing detailed recipient and client information for better insights.
MakeFreeReceive Google Sheet Data via REST API
Simple workflow which allows receiving data from a Google Sheet via REST endpoint. 1. Wait for Webhook Call 2. Get data from Google Sheet 3. Return data Example Sheet: [https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldfp5lvh8HtS0-pNXH66b7qGZIiGRU](https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldfp5lvh8HtS0-pNXH66b7qGZIiGRU)
n8n$2.99Automate Data Transfer via HTTP and Securely Store Files on SFTP Server
Streamline your data transfer process by sending data via HTTP and securely storing it on an SFTP server. This workflow ensures reliable data handling and storage for businesses.
Make$2.99Automate Lead Data Transfer from Facebook Lead Ads to Your API with HTTP Key Authentication
Effortlessly transfer new lead data from Facebook Lead Ads to your API using HTTP key authentication, enhancing your lead management process.
MakeFreeAutomate Airtable Record Creation from Wix Form Submissions
Automatically create a new Airtable record every time a Wix form is submitted, capturing all form details seamlessly.
Make$3.99Automate Google Sheets Row Filtering and Updates with HTTP Data Integration
Efficiently filter and update Google Sheets rows based on incoming data, and send data via HTTP requests for seamless integration.
Make$3.99Count the Items Returned by a Node
This workflow provides a simple approach to counting the items returned by a node. It uses a Set node with the Execute Once option:  The expression uses `$input.all()` (documented [here](https://docs.n8n.io/code-examples/methods-variables-reference/)) to fetch all incoming items at once, and `.length` (documented for example [here](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/length)) to count them.
n8n$3.99Automate SQL Server Queries and Populate Google Sheets
Automatically execute SQL Server queries and seamlessly transfer the results into Google Sheets for streamlined data management.
MakeFreeAutomatically Add New QuickCapture Events to Airtable Records
Seamlessly create a new Airtable record whenever a new project event is detected in QuickCapture, ensuring your data is always up-to-date.
MakeFreeProvide Latest Euro Exchange Rates from European Central Bank via Webhook
### What is this workflow doing? This simple workflow is pulling the latest Euro foreign exchange reference rates from the European Central Bank and responding with expected values to an incoming HTTP request (GET) via a Webhook trigger node. ### Setup - **No authentication** needed - The workflow is **ready to use** - **Test** the workflow template by hitting the test workflow button and calling the URL in the webhook node - Optional: choose your own Webhook listening path in the Webhook trigger node ### Usage There are two possible usage scenarios: 1. Get all Euro exchange rates as an array of objects 2. Get only a specific currency exchange rate as a single object #### All available rates Using the HTTP query `?foreign=USD` (where USD is one of the available currency symbols) will provide only that specifically asked rate. Response example: ```json {"currency":"USD","rate":1.0852} ``` #### Single exchange rate If no query is provided, all available rates are returned. Response example: ```json [{"currency":"USD","rate":1.0852},{"currency":"JPY","rate":163.38},{"currency":"BGN","rate":1.9558},{"currency":"CZK","rate":25.367},{"currency":"DKK","rate":7.4542},{"currency":"GBP","rate":0.85495},{"currency":"HUF","rate":389.53},{"currency":"PLN","rate":4.3053},{"currency":"RON","rate":4.9722},{"currency":"SEK","rate":11.1675},{"currency":"CHF","rate":0.9546},{"currency":"ISK","rate":149.30},{"currency":"NOK","rate":11.4285},{"currency":"TRY","rate":33.7742},{"currency":"AUD","rate":1.6560},{"currency":"BRL","rate":5.4111},{"currency":"CAD","rate":1.4674},{"currency":"CNY","rate":7.8100},{"currency":"HKD","rate":8.4898},{"currency":"IDR","rate":16962.54},{"currency":"ILS","rate":3.9603},{"currency":"INR","rate":89.9375},{"currency":"KRW","rate":1444.46},{"currency":"MXN","rate":18.5473},{"currency":"MYR","rate":5.1840},{"currency":"NZD","rate":1.7560},{"currency":"PHP","rate":60.874},{"currency":"SGD","rate":1.4582},{"currency":"THB","rate":38.915},{"currency":"ZAR","rate":20.9499}] ``` ### Further info Read more about Euro foreign exchange reference rates [here](https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html).
n8n$9.99Automate Data Submission to HTTP Endpoint from New Fillout Entries
Streamline your data integration by automatically sending new Fillout submissions to a specified HTTP endpoint using Make's Fillout and HTTP modules.
MakeFreeExtract and Process Phone Numbers from Facebook Lead Ads
Automatically extract phone numbers from new Facebook Lead Ads, parse them for validation, and send the formatted data to your system.
Make$4.99Sync Monday.com Item Updates to an HTTP Endpoint
Automatically synchronize updates from Monday.com items to a specified HTTP endpoint, ensuring real-time data consistency across platforms.
Make$3.99Format and Sync Data to Google Sheets
This workflow ensures that data is properly formatted before being inserted into Google Sheets. It involves renaming fields, selecting necessary fields, and adding timestamps to ensure compatibility with the destination spreadsheet. This is partic...
n8n$4.99Generate and Attach Survey Reports to Trello Cards Automatically
This workflow automates the creation of a feature report from Survey123 submissions and attaches the report to a new Trello card. It streamlines the process of documenting survey responses by integrating with Trello for organized task management.
Make$4.99Automate RSS Feed Monitoring and Secure Article Transmission
Automatically monitor RSS feeds for new articles and securely transmit them using HTTP with basic authentication. Enhance content delivery efficiency while ensuring data security.
Make$2.99Split in Batches Node currentRunIndex Example
This workflow demonstrates how to use `currentRunIndex` to get the running index.  **Function node:** This node generates mock data for the workflow. Replace it with the node whose data you want to split into batches. **SplitInBatches node:** This node splits the data with the batch size equal to `1`. Based on your use-case, set the value of the Batch Size. **IF node:** This node checks the running index. If the running index equals `5`, the node returns `true` and breaks the loop. The node uses the expression `{{$node[SplitInBatches].context[currentRunIndex]}}`, which returns the running index. **Set node:** This node prints a message `Loop Ended`. Based on your use-case, connect the false output of the IF node to the input of the node you want to execute if the condition is `false`.
n8n$4.99Split In Batches Node: noItemsLeft Example
This workflow demonstrates how to use `noItemsLeft` to check if there are items left to be processed by the SplitInBatches node.  **Function node:** This node generates mock data for the workflow. Replace it with the node whose data you want to split into batches. **SplitInBatches node:** This node splits the data with the batch size equal to `1`. Based on your use-case, set the value of the **Batch Size**. **IF node:** This node checks if all the data by the SplitInBatches are not processed or not. It uses the expression `{{$node[SplitInBatches].context[noItemsLeft]}}` which returns a boolean value. If there is data yet to be processed, the expression will return `false`, otherwise `true`. **Set node:** This node prints a message `No Items Left`. Based on your use-case, connect the false output of the *IF* node to the input of the node you want to execute, after the data is processed by the *SplitInBatches* node.
n8n$4.99Automate Email Validation and Cleanup in Airtable with TrueMail
Automatically validate new email entries in Airtable using TrueMail and remove invalid emails to maintain data integrity.
Make$3.99Automatically Record Survicate Survey Responses in Google Sheets
Effortlessly capture completed Survicate survey responses and store them in Google Sheets for easy analysis and tracking.
Make$3.99Automate Email Validation and Cleanup in Airtable with IPQualityScore
Automatically validate emails in Airtable records using IPQualityScore and remove invalid entries to maintain data integrity.
Make$3.99Automate Email Verification and Cleanup for New AWeber Subscribers
Automatically verify new AWeber subscriber emails using Clearout and remove invalid entries to maintain a clean mailing list.
Make$3.99Automate ClickUp to Google Sheets Sync with Row Filtering
Automatically sync ClickUp folder lists to Google Sheets, apply filters for organized data management, and add new entries for efficient project tracking.
Make$3.99Automate Airtable Updates from Filtered Google Sheets Data
Effortlessly update Airtable records by filtering data from Google Sheets. Enhance your data synchronization and management with this seamless integration.
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