n8n

How to Automate Google Sheets Image Alt Text SEO?

Improve website accessibility and SEO by auditing a web page and fixing short image alt text at scale. The flow scans a page, logs every image and its current alt text to Google Sheets, then uses AI to write better alt text for weak entries. It is great for content and SEO teams who want quick fixes without manual checks.

Run on demand with a URL you set. The system downloads the page HTML, parses each image and its alt text, and stores the page link, image source, a running index, and the alt text length. It then reads the sheet, picks images where the alt text length is under 50, limits the batch to five, and processes them one by one. An OpenAI vision model reviews the image URL and returns a concise alt text under 150 characters, which is written back to the sheet.

You need a Google Sheets connection and an OpenAI API key. Expect a fast audit per page and consistent, human friendly alt text, cutting review time from hours to minutes. Useful for before publishing checks, quarterly SEO cleanups, and accessibility improvements across content libraries.

What are the key features?

  • Manual trigger to run audits when you need them
  • URL input node to set the page you want to scan
  • HTTP fetch of page HTML to capture all image tags
  • Code step that extracts image sources, alt text, index, and alt length
  • Google Sheets append to store page, src, alt, index, and altLength
  • Google Sheets read to pull existing results for review
  • If filter that selects images with alt text length under 50
  • Limit and batch loop to process up to five images per run
  • OpenAI vision analysis that generates alt text under 150 characters
  • Google Sheets update that writes newAlt back using the stored index

What are the benefits?

  • Reduce manual image audits from 2 hours per page to 5 minutes
  • Automate up to 80 percent of alt text writing for weak entries
  • Improve accessibility and SEO by upgrading short or missing alt text
  • Control AI costs by limiting updates to 5 images per run
  • Keep one source of truth in Google Sheets for tracking and review

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. Connect Google Sheets: double click any Google Sheets node, open the Credential to connect with menu, click Create new credential, then follow the on screen steps to authorize your Google account. Name the credential clearly, for example Google Sheets SEO Alt Audit.
  4. Connect OpenAI: double click the Generate altText node, open the Credential to connect with menu, click Create new credential, then paste your OpenAI API key from the OpenAI API page. Name it OpenAI Alt Text.
  5. Set the target page: open the Page Link node and replace the sample URL with the web page you want to audit.
  6. Configure the Store Results node: choose your Google Sheet file and sheet tab. Map the columns to alt, src, page, index, and altLength as shown in the node.
  7. Test the audit: click Test workflow. Confirm that the sheet fills with one row per image and that altLength values look correct.
  8. Configure the Download Results and Update Results nodes to use the same Google Sheet file and sheet tab you used to store the audit data.
  9. Tune processing limits: open the Limit records node to change how many images get AI updates per run. Keep a small number at first to manage costs.
  10. Run AI updates: click Test workflow again. Watch the execution. The OpenAI step should return a short alt text which appears in the newAlt column.
  11. Validate outcomes: spot check several rows to ensure newAlt is clear, accurate, and under 150 characters. Adjust the prompt in Generate altText if needed.
  12. Troubleshoot: if no images are found, verify the page is public and the HTTP request returns 200. If sheet updates fail, confirm the index column exists and matches. If OpenAI errors, recheck the API key and model access.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Credits:
YouTube video

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.