Quick overview This workflow polls the CoinDesk RSS feed every 10 minutes, filters for crypto-related stories, checks Google Sheets to avoid duplicates, uses OpenAI to score and summarize risk, logs results to Google Sheets, and sends Gmail alerts when the risk priority is HIGH or MEDIUM. How it works Polls the CoinDesk RSS feed every 10 minutes and retrieves the latest articles. Extracts each article’s title, description, link, and publish date, generates an article ID, and filters to only crypto-relevant items using a keyword match. Checks a Google Sheets “Seen Articles” tab to skip any article IDs that have already been processed. Sends the article text to the OpenAI Chat Completions API to return a JSON risk assessment including summary, coins, risk level, score, and recommended action. Parses the OpenAI response, normalizes the risk level into a HIGH/MEDIUM/LOW priority, and appends the article ID to the “Seen Articles” tab and the full analysis to a “Risk Log” tab in Google Sheets. Sends a formatted Gmail alert email for articles marked HIGH or MEDIUM priority. Setup Add an OpenAI API credential (OpenAI API) for the HTTP request to the Chat Completions endpoint.
Tags
Gmail
Google SheetsWHTTP RequestRelated workflows
See all Gmail→WRoute law firm client intakes with Claude and Google Sheets
Quick Overview This workflow hosts an n8n intake form for a law firm, sends each submission to Anthropic Claude for classification and qualification, logs the result to Google Sheets, emails the intake team for qualified matters via Gmail, and returns a neutral confirmation page to the submitter. How it works Receives a client intake submission through an n8n hosted form. Normalizes the submission into consistent fields (contact details, matter type, incident date, and narrative). Sends the normalized intake to Anthropic Claude to classify practice area, assess urgency and time sensitivity, flag conflict-check needs, and decide whether the matter is qualified. Parses Claude’s JSON response and merges the analysis back into the intake record. If the matter is qualified, sends an HTML alert email via Gmail to the intake team and appends the intake details to the “Qualified Intakes” tab in Google Sheets. If the matter is not qualified, appends the submission and decline reason to the “Declined Intakes” tab in Google Sheets. Returns a confirmation message to the submitter stating the intake was received and that no attorney-client relationship has been formed. Setup Create an Anthropic
WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
W
Automate Paid Zoom Meetings with Stripe, Gmail & Google Sheets Tracking
Streamline Your Zoom Meetings with Secure, Automated Stripe Payments This comprehensive workflow automates the entire process of setting up a paid online event, from scheduling a Zoom meeting and creating a Stripe payment link to tracking participants and sending confirmation emails. How it Works This workflow has two primary, distinct branches: Event Creation and Participant Registration. Event Creation Flow (Triggered via Form): An administrator submits details (title, price, date/time) via a form. The workflow creates a new Zoom meeting with a unique password. It creates a Stripe Product and a Payment Link. A dedicated Google Sheet tab is created for tracking participants. An email is sent to the event organizer with all the details, including the Zoom link, payment link, and participant list URL. Participant Registration Flow (Triggered via Stripe Webhook): A webhook is triggered when a Stripe payment is completed (checkout.session.completed). The participant's details are added to the dedicated Google Sheet tab. A confirmation email is sent to the participant with the Zoom link and password. A notification email is sent to the event organizer about the new registration. Use Ca