Automate Agricultural Market Price Tracking to Google Sheets
detail.loadingPreview
Effortlessly track and log crucial agricultural market price data directly into your Google Sheets with this n8n workflow. It automates fetching daily crop quotations from official government APIs, providing a streamlined way to monitor market trends and inform your decisions.
About This Workflow
This n8n workflow provides a robust solution for anyone needing to monitor agricultural market prices. It connects directly to the official Taiwan Ministry of Agriculture's data API (data.moa.gov.tw) to fetch daily or historical market quotations for various agricultural products, including specific market locations like 'Taipei 2'. After retrieving the raw JSON data, the workflow intelligently parses and individualizes each market entry. Finally, it seamlessly appends this structured information—such as transaction dates, crop names, market names, and price ranges (upper, middle, lower, average) along with transaction quantities—into a designated Google Sheet. This automation ensures you always have up-to-date market insights without manual data entry, empowering better agricultural planning and financial analysis.
Key Features
- Automated Data Retrieval: Automatically pulls daily or historical agricultural market data from official government APIs.
- Configurable Market & Date Ranges: Easily specify start/end dates and target specific markets (e.g., Taipei 2) for focused data collection.
- Seamless Google Sheets Integration: Directly append parsed market data (transaction dates, crop names, prices, quantities) to your chosen Google Sheet.
- Structured Data Output: Ensures clean, organized data ready for analysis in your spreadsheet.
- No-Code API Interaction: Simplifies complex API calls without writing any code, using n8n's visual interface.
How To Use
- Manual Trigger: This workflow starts manually. Click 'Test workflow' or 'Run workflow' to execute. You can also configure a 'Cron' node instead to schedule it to run automatically at specific intervals.
- HTTP Request Node:
- Update the
Start_timeandEnd_timequery parameters to define your desired data collection period. - Modify the
MarketNamequery parameter to specify the agricultural market you wish to track (e.g., "高雄" for Kaohsiung). - Crucially: Replace
api_keywith your valid API key obtained from thedata.moa.gov.twplatform.
- Update the
- Google Sheets Node:
- Connect your Google Sheets account using the OAuth2 credential setup if you haven't already.
- Select your target
documentId(Google Sheet file) andsheetNamewhere the agricultural data will be appended. - Ensure the
operationis set to "Append" to add new rows of data.
- Activate Workflow: Once configured, set the workflow to 'Active' to enable scheduled or manual runs.
Apps Used
Workflow JSON
{
"id": "144835da-e3f1-402d-9cb5-4046378ae2a1",
"name": "Automate Agricultural Market Price Tracking to Google Sheets",
"nodes": 17,
"category": "Operations",
"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: 144835da-e3f1...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
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.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.