Quick overview Automatically fetches live commodity quotes (gold, silver, crude oil, natural gas, and more) using an Octagon AI Agent, then writes prices, changes, ranges, volume, and moving averages back to a Google Sheet. How it works Reads commodity symbols (GCUSD, SIUSD, CLUSD, NGUSD, etc.) from a Google Sheet. Fetches the live commodities-quote Skill from GitHub and builds an Octagon Agent prompt for each symbol. Calls the Octagon Agent for real-time quotes and parses the response. Writes the price, change, ranges, volume, and moving averages back to the sheet. Setup Set aside about 5 minutes to complete the configuration. Connect your Google Sheets, OpenAI, and Octagon credentials. Point the Sheets nodes at your commodities sheet, making sure it has a Symbol or Ticker column. Ensure date ranges are in the Sheet. Review the sticky notes inside the workflow for detailed configuration notes.
Tags
Google SheetsWHTTP RequestOpenAIRelated workflows
See all AI Automation→WGenerate weekly Pinterest content opportunity briefs with Apify, OpenAI and Google Sheets
Quick overview Research a Pinterest niche with FetchCat's Pinterest Search Scraper, preserve every source pin in Google Sheets, and use one evidence-controlled OpenAI call to identify recurring themes, underrepresented angles, and five production-ready content briefs without claiming search volume or trend growth. How it works Starts manually with one research niche and one to five exact Pinterest search phrases, plus locale, country, and a configurable result limit. Runs fetch_cat/pinterest-search-scraper through a Cloud-compatible HTTP Request and collects 20 to 500 public pins per search with public detail enrichment enabled. Validates, normalizes, and deduplicates returned pins. It stops before AI or destination writes when fewer than ten usable pins remain. Builds stable Google Sheets rows, deterministic phrase counts, and a bounded evidence packet, then uses one structured gpt-5.4-mini request for analysis. Removes invalid pin citations and rejects any finding that retains no supplied evidence, preventing unsupported recommendations from reaching the destination. Upserts source pins and a readable brief into separate Pins and Research Brief tabs using stable same-day research
CWExtract and log Gmail receipt expenses with OpenAI, Sheets and Airtable
Quick overview This workflow monitors a Gmail “Receipts” label, downloads attachments, uses OpenAI to extract expense data from receipt emails and images, skips duplicates and non-receipts, fails safely when extraction is unreadable, sends Slack/Teams alerts for high-value, warranty, or review-needed receipts, and logs valid receipts to Sheets or Airtable. How it works Triggers every minute when Gmail finds new emails matching the query label:Receipts newer_than:2d. Normalizes the email into consistent fields (message ID, subject, sender, received date, plain-text body) and generates a receipt hash for stable matching. Searches Airtable and/or Google Sheets for existing records matching the message ID or receipt hash and marks the email as a duplicate if it falls within the configured duplicate window. For new receipts, sends the email content to OpenAI to extract receipt details like merchant, total, category, line items, tax hints, and return/warranty dates. Evaluates the extraction to flag high-value, warranty/return-relevant, or needs-review receipts and formats alert messages. Posts alerts to Slack and/or Microsoft Teams when enabled and the receipt is not “standard.” Appends
CWExtract and log Gmail admin tasks with OpenAI, Google Sheets and Airtable
Quick overview This workflow monitors Gmail for messages labeled “Admin”, redacts sensitive data, uses OpenAI to extract structured admin tasks and reminders, skips duplicates by checking Google Sheets and/or Airtable, sends optional Slack or Microsoft Teams alerts for urgent items, and logs the clean task details. How it works Triggers every minute when a new Gmail message matches the query label:Admin newer_than:7d. Loads configurable settings (log destination, alert channels, due-soon window, dedupe window, and redaction toggle) and normalizes the email into a clean text body. Redacts sensitive patterns (such as SSNs, card-like numbers, phone numbers, email addresses, and addresses) and generates an “admin hash” fingerprint for deduplication. Checks Google Sheets and/or Airtable for recent matching Message IDs or admin hashes and skips processing if the email appears to be a duplicate. Sends the redacted email content to OpenAI to classify whether it is an admin item and to extract fields like task title, summary, priority, due date/time, and recommended next step. If the item is valid, optionally posts an alert to Slack and/or Microsoft Teams for urgent/high-priority, due-soon,