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 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.
Automated Multi-Platform Influencer Discovery & Qualification
This powerful n8n workflow automates the entire process of discovering, scoring, and qualifying ideal influencers across Instagram, TikTok, and YouTube for your marketing campaigns. Streamline your talent acquisition by leveraging custom criteria and a sophisticated scoring algorithm.
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.
Smart Expense Tracking with Telegram & AI
Automate your personal finance management by turning your Telegram chat into an intelligent expense tracker. Simply send a photo of a receipt or a text message, and this workflow uses AI to categorize your spending, extract crucial details, and provide instant summaries.