Automate Agricultural Data with n8n & Google Sheets
detail.loadingPreview
Seamlessly fetch agricultural market data and automatically populate your Google Sheets. This workflow automates the tedious task of data collection, saving you time and ensuring your records are always up-to-date.
About This Workflow
This n8n workflow is designed to streamline the process of collecting agricultural market quotation data. It leverages the Taiwan Ministry of Agriculture's public API to retrieve specific market data for a given period and market. The data is then processed, split into individual records, and automatically appended to a designated Google Sheet. This automation eliminates manual data entry, reduces errors, and provides a centralized, accessible record of crucial agricultural price information for analysis and decision-making.
Key Features
- Automated Data Fetching: Connects to the official agricultural API to pull real-time market data.
- Customizable Data Filtering: Specify date ranges (Start_time, End_time) and market names (MarketName) for targeted data retrieval.
- Seamless Google Sheets Integration: Automatically appends fetched data to a specified Google Sheet.
- Data Structuring: Splits and formats raw API data for easy insertion into spreadsheet columns.
- API Key Security: Securely handles API keys for accessing protected data sources.
How To Use
- Trigger: The workflow starts when you manually test it by clicking 'Test workflow'.
- HTTP Request Node: Configure the
urlto the agricultural API endpoint (https://data.moa.gov.tw/api/v1/SheepQuotation). SetStart_time,End_time,MarketName, and yourapi_keyin thequeryParameters. - Split Out Node: Ensure the
fieldToSplitOutis set toDatato process each item within the API response individually. - Google Sheets Node: Configure your Google Cloud credentials for Google Sheets access. Specify the
documentId(your Google Sheet ID) andsheetName(or thegidfor a specific sheet). Map the incoming data fields from the 'Split Out' node to the corresponding columns in your Google Sheet by ensuring theidanddisplayNamein thecolumns.schemamatch your sheet's headers.
Apps Used
Workflow JSON
{
"id": "445bf476-a4b7-43e2-ad75-9fbc985ea61e",
"name": "Automate Agricultural Data with n8n & Google Sheets",
"nodes": 13,
"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: 445bf476-a4b7...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
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.