Sheep Market Data Automation

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.

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.

1. 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.