n8n-農產品

For n8n, automate the retrieval of sheep market data from an API, split the results for detailed analysis, and seamlessly append the data to Google Sheets. This workflow simplifies data collection and organization, enabling efficient tracking of market trends and pricing from December 1 to December 31, 2024.

7/4/2025
4 nodes
Simple
yavjrtdjoqvaenu3manualsimplesplitoutgooglesheetsapiintegration
Categories:
Manual TriggeredSimple WorkflowData Processing & Analysis
Integrations:
SplitOutGoogleSheets

Target Audience

This workflow is ideal for:
- Farmers and Agricultural Producers: To track and analyze market prices for sheep products in a specific market (台北二).
- Market Analysts: To gather data for market research and price trends in the agricultural sector.
- Data Analysts: To automate the extraction and organization of data into Google Sheets for further analysis.
- Business Owners in Agriculture: To make informed decisions based on real-time market data.

Problem Solved

This workflow addresses the challenge of manually collecting and organizing agricultural market data. By automating the retrieval of sheep price quotations from the Taiwan Ministry of Agriculture API and appending this data directly into Google Sheets, users can save time, reduce errors, and enhance their ability to analyze pricing trends effectively.

Workflow Steps

  • Manual Trigger: The workflow begins with a manual trigger when the user clicks 'Test workflow'.
    2. HTTP Request: It sends an HTTP request to the Taiwan Ministry of Agriculture API to fetch sheep price quotations for the period from December 1, 2024 to December 31, 2024 in the 台北二 market. The request includes an API key for authentication and specifies that the response should be in JSON format.
    3. Split Out Node: The response data is then split into individual records using the Split Out node, which allows each record to be processed separately.
    4. Google Sheets Integration: Finally, each record is appended to a specified Google Sheet (identified by its document ID), allowing users to view and analyze the data in a structured format.

    • Customization Guide

    Users can customize this workflow by:
    - Changing the API Endpoint: Modify the URL in the HTTP Request node to fetch data from different endpoints or APIs.
    - Adjusting Query Parameters: Update the Start_time, End_time, and MarketName values to target different time frames or markets.
    - Modifying Google Sheets Configuration: Change the sheetName and documentId to store data in different sheets or documents. Ensure the column mapping in the Google Sheets node matches the data structure from the API response.
    - Adding Additional Processing Nodes: Users can insert additional nodes between the HTTP Request and Google Sheets nodes to perform data transformations or filtering as needed.