Data & Analytics Workflows
Data processing and analytics
Send data to Google Sheets and update a cell with new information
Automatically send data to Google Sheets and update a specific cell with new information using HP and Google Sheets modules.
MakeFreeAutomate Weekly Mollie Settlements to Excel
Effortlessly retrieve and organize Mollie settlements with detailed period line information into an Excel spreadsheet on a weekly basis.
MakeFreeAutomate IP Address Lookup from Google Forms Responses with IP2Proxy
Automatically monitor new Google Forms responses to retrieve IP addresses and use IP2Proxy to gather detailed information, updating the form with enriched data.
Make$3.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.99Validate and Store Emails and Phone Numbers via Webhooks
This workflow captures email and phone data via webhooks, validates them using regular expressions, and stores valid entries in a data store. Invalid entries receive a response through webhooks.
Make$2.99Automate Article Insights to Google Sheets with Perplexity AI
Streamline your content tracking by automatically updating Google Sheets with insights from new articles using Perplexity AI chat completions triggered by RSS feeds.
Make$3.99Automate Table Creation and Data Insertion in CrateDB
This workflow automates the process of creating a table in CrateDB and inserting data into it, triggered manually.
n8n$4.99Automate Sentiment Analysis and Posting of Tweets
This workflow automates the collection of tweets, analyzes their sentiment, stores them in databases, and posts positive tweets to a Slack channel.
n8n$9.99Google SERP Tracker + Trends & AI Recommendations
Automates Google SERP extraction via Bright Data, parses with Gemini AI for structured data, generates trends/recommendations, exports CSV reports, and sends webhook notifications.
n8n$24.99Automate 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.99Unix Timestamp to ISO Date Converter
This n8n workflow provides a simple yet powerful utility to convert Unix timestamps (seconds since epoch) into the universally recognized ISO 8601 date and time format. This is crucial for harmonizing date data across different systems, databases, and applications. --- # How it works - Receive Timestamp Webhook: This node acts as the entry point, listening for incoming POST requests. It expects a JSON body containing a single property: timestamp, which should be a Unix timestamp in seconds (e.g., 1678886400). - Convert to ISO 8601: This node takes the timestamp received from the webhook. Since JavaScript's Date object typically uses milliseconds, it multiplies the Unix timestamp by 1000. It then uses new Date(...).toISOString() to convert this into an ISO 8601 formatted string (e.g., 2023-03-15T00:00:00.000Z) and assigns it to a new property called convertedTime. - Respond with Converted Time: This node sends the convertedTime property back as the response to the original webhook caller. --- # Who is it for? ### This workflow is extremely useful for: - Developers & Integrators: When working with APIs or databases that return dates as Unix timestamps, and you need to display them in a human-readable or standardized format in your applications or dashboards. - Data Analysts & Scientists: For cleaning and transforming raw timestamp data from logs, event streams, or legacy systems into a consistent format for analysis. - System Administrators: For debugging logs where timestamps are often in Unix format. - Anyone Managing Data Imports/Exports: Ensuring date compatibility when moving data between different platforms. - Automators: As a building block in larger workflows where incoming data has Unix timestamps that need to be normalized before further processing (e.g., adding to a spreadsheet, sending in an email, or performing date calculations). --- # Data Structure When you trigger the webhook, send a POST request with a JSON body structured as follows: ``` { "timestamp": 1678886400 } ``` The workflow will return a JSON response similar to this: ``` { "convertedTime": "2023-03-15T00:00:00.000Z" } ``` --- # Setup Instructions - Import Workflow: In your n8n editor, click Import from JSON and paste the provided workflow JSON. - Configure Webhook Path: - Double-click the Receive Timestamp Webhook node. - In the Path field, set a unique and descriptive path (e.g., /convert-timestamp or /unix-to-iso). - Activate Workflow: Save and activate the workflow. --- # Tips This simple conversion workflow can be drastically enhanced and leveraged in many ways: - Dynamic Output Formats: - Upgrade: Modify the Convert to ISO 8601 node (or add a Function node after it) to accept an optional format parameter in the webhook. - Leverage: Allow users to request formats like MM/DD/YYYY HH:mm:ss, YYYY-MM-DD, DD-MM-YYYY, or just the time, making the output directly usable in various contexts without further processing. - Example using a Function node: ``` const date = new Date($json.timestamp * 1000); const format = $json.format || "iso"; // Default to ISO let output; switch (format.toLowerCase()) { case "iso": output = date.toISOString(); break; case "locale": // e.g., 3/15/2023, 12:00:00 AM UTC output = date.toLocaleString("en-US", { timeZone: "UTC" }); break; case "dateonly": // e.g., 2023-03-15 output = date.toISOString().split('T')[0]; break; case "timeonly": // e.g., 00:00:00 UTC output = date.toLocaleTimeString("en-US", { timeZone: "UTC", hour12: false }); break; default: output = date.toISOString(); // Fallback } return [{ json: { convertedTime: output } }]; ``` - Timezone Conversion: - Upgrade: Combine this with the Time Zone Converter workflow (or integrate moment-timezone.js if using a Code node and have a self-hosted instance). Accept an optional targetTimeZone parameter in the webhook. - Leverage: Convert the Unix timestamp directly into a human-readable date and time in a specific target timezone, which is incredibly valuable for global scheduling or reporting. - Error Handling and Input Validation: - Upgrade: Add an IF node after the Receive Timestamp Webhook. Check if isNaN($json.body.timestamp) or if typeof $json.body.timestamp !== "number". - Leverage: If the input timestamp is invalid, branch to a Respond to Webhook node that returns a clear error message (e.g., Invalid timestamp provided. Please provide a numeric Unix timestamp in seconds.). This makes your API more robust. - Reverse Conversion (ISO to Unix): - Upgrade: Create a separate workflow, or add another branch to this one, to convert an ISO 8601 string back to a Unix timestamp. This provides a complete conversion utility. - Example Set node value: `={{ new Date($json.body.isoString).getTime() / 1000 }}` - Integration with Data Pipelines: - Upgrade: Use this workflow as a microservice in larger E
n8n$4.99Transform Gmail Newsletters into Insightful LinkedIn Posts Using OpenAI
Automates extracting key insights from Gmail newsletters and generating engaging LinkedIn posts with OpenAI, saving time for marketers and creators.
n8n$14.99Scheduled Website Uptime Monitor with Slack Alert
Automates periodic website uptime checks via HTTP requests and sends instant Slack alerts if the site is down (non-2xx status). Ideal for monitoring critical sites or APIs.
n8n$9.99Automate Data Transfer from Cognito Forms to Smartsheet
Effortlessly manage your data by automatically adding new Cognito Forms entries as rows in Smartsheet. This integration streamlines data handling, reducing manual entry and minimizing errors.
Make$2.99Automate Facebook Ad Insights to Google Sheets for Real-Time Analysis
Streamline your data analysis by automatically fetching Facebook Ad Account insights, processing them, and updating Google Sheets for real-time insights.
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 Squarespace Blog and Event Data Export to Google Sheets
Effortlessly export and update your Squarespace blog and event collections into Google Sheets. This workflow ensures your data is always current by fetching items in paginated batches and appending them to a spreadsheet.
n8n$4.99Sync RSS Feed Articles to Airtable Records Automatically
Effortlessly keep your Airtable database up-to-date by syncing new articles from RSS feeds. This workflow automates the process of reading RSS feeds and creating corresponding records in Airtable.
Make$2.99Automate Data Transfer from Google Sheets to HTTP Endpoints
Streamline your workflow by automatically sending updated data from Google Sheets to specified HTTP endpoints for seamless integration and real-time processing.
Make$3.99Automatically Log Wootric Survey Responses to Google Sheets
Effortlessly track Wootric survey responses by automatically adding them to a Google Sheets spreadsheet, ensuring all feedback is organized and accessible.
Make$2.99Automate Airtable Record Creation from GetForm Submissions
Automatically create new records in Airtable whenever a form is submitted via GetForm, ensuring seamless data transfer and organization.
MakeFreeAutomatically Transfer Typeform Leads to Google Sheets
Streamline your data management by automatically transferring new Typeform submissions to a Google Sheets spreadsheet for easy storage and analysis.
MakeFreeAutomatically Log Survey Anyplace Responses to Google Sheets
Streamline data collection by automatically adding new Survey Anyplace responses to a Google Sheets spreadsheet, ensuring your data is organized and accessible.
Make$2.99Automate Social Media Posts from Google Sheets to FB, Twitter, LinkedIn & Slack
Triggers on new Google Sheets rows to post content to selected social platforms (FB, Twitter, LinkedIn), updates status, and notifies via Slack for efficient marketing automation.
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