Google Sheets Records By Date and Status
detail.loadingPreview
Fetch records from Google Sheets filtered by date range and status using a sub-workflow.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This template leverages a sub-workflow to fetch records from Google Sheets, allowing filtering by a specified date range and transaction status. It addresses the complexity of date filtering in the Google Sheets API and transforms the output into a usable JSON format.
Key Features
- Fetches records from Google Sheets.
- Filters records by a start date and end date.
- Filters records by transaction status (Completed, Refund, Error).
- Transforms messy API output into structured JSON.
- Uses a sub-workflow to handle complex filtering logic.
How To Use
- Import this workflow.
- Ensure you have a Google Sheets API credential configured.
- The sub-workflow
Template | Your first AI Data Analyst(ID:a2BIIjr2gLBay06M) needs to be set up to handle the Google Sheets interaction. - Trigger the main workflow with
start_date,end_date, and optionallystatusinputs.
Apps Used
Workflow JSON
{
"id": "005a0e6a-3a6b-4865-a655-269c7127b337",
"name": "Google Sheets Records By Date and Status",
"nodes": 0,
"category": "Data Fetching",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 005a0e6a-3a6b...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Read RSS Feed from Two Sources
Reads data from two different RSS feeds and processes it.
Hacker News Top Posts Fetcher
Fetches and cleans data about the top 50 posts ever on Hacker News.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
AI-Powered Abandoned Cart Recovery & Nurturing
This n8n workflow intelligently identifies customers who've abandoned their shopping carts, leverages AI to craft personalized recovery emails, and automatically sends them. It then logs all activity to Google Sheets for seamless tracking and optimization of your sales recovery efforts.
AI-Powered Amazon Competitor Review Analysis
Automate competitor insights by scraping Amazon product reviews, storing them in Google Sheets, and leveraging AI for intelligent summarization. This workflow provides a seamless solution to stay ahead of the competition and inform your product strategy with real-time customer feedback.