Plant Care Reminder with OpenWeather, Google Sheets, and Telegram

This n8n workflow automates plant care reminders by integrating weather data, plant schedules from Google Sheets, and sending notifications via Telegram. It helps you keep your plants healthy by reminding you when to water them based on local weather conditions.

What it does

1. Triggers on a Schedule: The workflow runs automatically at predefined intervals (e.g., daily).
2. Fetches Plant Data: It reads plant care schedules and details from a specified Google Sheet.
3. Gets Local Weather: It retrieves current weather conditions for a specified location using a custom HTTP request (likely to OpenWeatherMap or a similar service).
4. Processes Plant Data: It likely processes the plant data, potentially combining it with weather information to determine if a plant needs watering.
5. Conditional Logic: It uses an "If" node to apply conditional logic, probably to check if a watering reminder is due based on the combined data.
6. Prepares Telegram Message: If a reminder is due, it prepares a message to be sent.
7. Sends Telegram Notification: It sends a personalized plant care reminder to a Telegram chat.
8. Responds to Webhook (Optional/Placeholder): Includes a "Respond to Webhook" node, which might be a leftover or intended for future expansion to acknowledge external triggers.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google account with access to Google Sheets. You'll need to create a sheet with your plant care schedule (e.g., plant name, last watered date, watering frequency, location).
• OpenWeatherMap (or similar weather API) API Key: An API key for a weather service to fetch local weather data. This will be used in the HTTP Request node.
• Telegram Bot Token: A Telegram bot token and the chat ID where you want to receive notifications.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON content or upload the file.

2. Configure Credentials:

   • Google Sheets:
     • Click on the "Google Sheets" node.
     • Under "Credentials", click "Create New".
     • Choose "Google Sheets API" and follow the instructions to authenticate your Google account. Ensure it has access to the spreadsheet you'll be using.
   • Telegram:
     • Click on the "Telegram" node.
     • Under "Credentials", click "Create New".
     • Choose "Telegram API" and enter your Telegram Bot Token. You'll also need to specify the Chat ID in the node's configuration.

3. Configure Nodes:

   • Schedule Trigger: Adjust the "Interval" to your desired frequency (e.g., once a day).
   • Google Sheets:
     • Specify the "Spreadsheet ID" and "Sheet Name" where your plant data is stored.
     • Configure the "Operation" to "Read" and "Read All Rows" or similar to fetch all plant data.
   • HTTP Request (Weather API):
     • Edit the "HTTP Request" node.
     • Set the "URL" to your chosen weather API endpoint (e.g., OpenWeatherMap API).
     • Include your API key and the desired location (latitude/longitude or city name) as query parameters or headers, as required by the API.
     • Ensure the "Method" is GET.
   • Edit Fields (Set): This node might be used to prepare data for the "If" condition or the Telegram message. Review and adjust its expressions based on your Google Sheet columns and desired message content.
   • If:
     • Configure the "If" node to define the conditions under which a reminder should be sent (e.g., lastWateredDate is older than wateringFrequency days AND weatherCondition is not raining).
   • Telegram:
     • In the "Telegram" node, set the "Chat ID" to your target Telegram chat.
     • Craft the "Text" message using expressions to include dynamic data like plant name, last watered date, and weather information.

4. Activate the Workflow:

   • Once all credentials and nodes are configured, save the workflow.
   • Toggle the workflow "Active" switch to enable it.

The workflow will now run on its schedule, check your plant care needs against the weather, and send you Telegram reminders!