Quick Overview
This workflow runs daily (or manually) to pull the last 24 hours of AI and blockchain headlines from Google News via SerpAPI, uses Groq Llama 3.3 to draft Twitter/X and LinkedIn posts, generates a matching image with Pollinations, then saves everything to Google Sheets and notifies Slack.
How it works
- Runs on a daily 8 AM schedule (or via a manual trigger for testing).
- Queries Google News through SerpAPI for the last day’s AI, artificial intelligence, blockchain, and crypto headlines.
- Builds a numbered news digest and stops with an error if no results are returned.
- Sends the digest to Groq (Llama 3.3 70B) to generate a Twitter/X post and a LinkedIn post in JSON format.
- Generates a 1024×1024 social image with Pollinations based on the Twitter/X post, then uploads it to Google Drive and makes it publicly accessible.
- Appends the generated posts and public image URL to Google Sheets, logs the successful run to a separate sheet, and posts a success notification to a Slack channel.
Setup
- Add a SerpAPI credential using HTTP Query Auth and provide your API key as the
api_key query parameter.
- Add a Groq API credential and ensure the Groq Llama 3.3 chat model is selected.
- Add a Pollinations Bearer token credential (or adjust the request to use the anonymous tier if applicable).
- Connect Google Drive OAuth and choose the destination folder (or leave it as My Drive) for image uploads.
- Connect Google Sheets OAuth and select the target spreadsheet and sheet tabs for both the content append and the run log append steps.
- Connect Slack OAuth and set the channel where the workflow posts the success notification.