Insert and read data from Google Sheets

Name: Insert and read data from Google Sheets
Availability: InStock
Rating: 4.5 (1291 reviews)
Author: amudhan

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Companion workflow for Google Sheets node docs

workflow-screenshot

amudhan

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

beginner

Published 11 Aug 2020

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Send package and visitor alerts with Slack, SMS, email, Google Sheets and Claude

## Who this is for Property management teams handling multiple properties with high package/visitor traffic who want automated tenant and management notifications. ## What this workflow does Automatically classifies package and visitor events, sends notifications to tenants, alerts property managers, and logs activity for accountability. ## How it works 1. Package/visitor system triggers workflow. 2. AI classifies urgency and type. 3. Notifications sent via Email, SMS, and Slack. 4. Google Sheets logs all events. 5. Optional AI follow-up suggestions for unclaimed packages or missed visitors. ## How to set up Connect Webhook, Slack, Email, SMS, and AI. Test routing and logging. Adjust AI prompts for local building protocols. ## Requirements - AI Node - Webhook from package/visitor system - Slack, Email, SMS credentials - Google Sheets Built by QuarterSmart. Created by Hyrum Hurst.

View

Send daily Malaysian weather alerts with Perplexity AI, Firecrawl and Telegram

## Automated Malaysian Weather Alerts with Perplexity AI, Firecrawl and Telegram This n8n template automates daily weather monitoring by fetching official government warnings and searching for related news coverage, then delivering comprehensive reports directly to Telegram. Use cases include monitoring severe weather conditions, tracking flood warnings across Malaysian states, staying updated on weather-related news, and receiving automated daily weather briefings for emergency preparedness. ### Good to know - Firecrawl free tier allows limited scraping requests per hour. Consider the 3-second interval between requests to avoid rate limits. - OpenAI costs apply for content summarization - GPT-4.1 mini balances quality and affordability. - After testing multiple AI models (GPT, Gemini), **Perplexity Sonar Pro Search proved most effective** for finding recent, relevant weather news from Malaysian sources. - The workflow focuses on major Malaysian news outlets like Utusan, Harian Metro, Berita Harian, and Kosmo. ### How it works 1. Schedule Trigger runs daily at 9 AM to fetch weather warnings from Malaysia's official data.gov.my API. 2. JavaScript code processes weather data to extract warning types, severity levels, and affected locations. 3. Search queries are aggregated and combined with location information. 4. Perplexity Sonar Pro AI Agent searches for recent news articles (within 3 days) from Malaysian news channels. 5. URLs are cleaned and processed one by one through a loop to manage API limits. 6. Firecrawl scrapes each news article and extracts summaries from main content. 7. All summaries and source URLs are combined and sent to OpenAI for final report generation. 8. The polished weather report is delivered to your Telegram channel in English. ### How to use - The schedule trigger is set for 9 AM but can be adjusted to any preferred time. - Replace the Telegram chat ID with your channel or group ID. - The workflow automatically filters out "No Advisory" warnings to avoid unnecessary notifications. - Modify the search query timeout and batch processing based on your API limits. ### Requirements - OpenAI API key (get one at [https://platform.openai.com](https://platform.openai.com)) - Perplexity API via OpenRouter (get access at [https://openrouter.ai](https://openrouter.ai)) - Firecrawl API key (get free tier at [https://firecrawl.dev](https://firecrawl.dev)) - Telegram Bot token and channel/group ID ### Customizing this workflow - **Expand news sources**: Modify the AI Agent prompt to include additional Malaysian news outlets or social media sources. - **Language options**: Change the final report language from English to Bahasa Malaysia by updating the "Make a summary" system prompt. - **Alert filtering**: Adjust the JavaScript code to focus on specific warning types (e.g., only severe warnings or specific states). - **Storage integration**: Connect to Supabase or Google Sheets to maintain a historical database of weather warnings and news. - **Multi-channel delivery**: Add more notification nodes to send alerts via email, WhatsApp, or SMS alongside Telegram.

View

Predict disaster damage and coordinate property response with GPT-4, Google Sheets, Calendar and Gmail

## How It Works This automated disaster response workflow streamlines emergency management by monitoring multiple alert sources and coordinating property protection teams. Designed for property managers, insurance companies, and emergency response organizations, it solves the critical challenge of rapidly identifying at-risk properties and deploying resources during disasters.The system continuously monitors weather, seismic, and flood alerts from authoritative sources. When threats are detected, it cross-references property databases to identify affected locations, calculates insurance exposure, and generates damage assessments using OpenAI's GPT-4. Teams receive automated maintenance schedules while property owners and insurers get instant email notifications with comprehensive reports. This eliminates manual monitoring, reduces response time from hours to minutes, and ensures no vulnerable properties are overlooked during emergencies. ## Setup Steps 1. Configure alert fetch nodes with weather/seismic/flood API endpoints 2. Connect property database credentials (specify database type) 3. Add OpenAI API key for GPT-4 damage assessments 4. Set up Gmail/SMTP credentials for owner and insurer notifications 5. Customize insurance calculation formulas and team scheduling logic ## Prerequisites Weather/seismic/flood alert API access, property database (SQL/Sheets/Airtable) ## Use Cases Insurance companies automating claims preparation, property management firms protecting rental portfolios ## Customization Modify alert source APIs, adjust damage assessment prompts ## Benefits Reduces emergency response time by 90%, eliminates manual alert monitoring

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.