Scrape, Structure, and Store News Data using Decodo, Gemini AI and Google Sheets

Sign up for Decodo HERE for Discount Automatically scrape, structure, and log forum or news content using Decodo and Google Gemini AI. This workflow extracts key details like titles, URLs, authors, and engagement stats, then appends them to a Google Sheet for tracking and analysis. Who’s it for? Ideal for data journalists, market researchers, or AI enthusiasts who want to monitor trending topics across specific domains. How it works Trigger: Workflow runs on schedule. Data Setup: Defines forum URLs and geolocation. Scraping: Extracts raw text data using the Decodo API. AI Extraction: Gemini parses and structures the scraped text into clean JSON. Data Storage: Each news item is appended or up

Help me set up the n8n workflow "Scrape, Structure, and Store News Data using Decodo, Gemini AI and Google Sheets" (https://n8n.io/workflows/9965). It uses: Google Sheets, Crypto, Basic LLM Chain, Structured Output Parser, Google Gemini Chat Model. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.