Extract the news URLs from Google Sheets with GPT, translate them, and publish in WordPress
Your news feed, from Google Sheets to WordPress, translated and published—automatically. No headaches, no tech jargon.
Manually gathering news URLs from Google Sheets, extracting content, translating each article, and publishing them on WordPress is a time-consuming chore that eats up hours every week. Each step—copying the link, scraping content, running translations, formatting, and posting—invites human error and creates massive delays in sharing up-to-date news with your audience. Failing to automate this workflow means falling behind on publishing, losing competitive visibility, and wasting valuable energy on repetitive tasks instead of growing your content strategy.
This Botize formula is your autopilot for multilingual news publishing: it periodically scans your Google Sheet for new news URLs, prompts GPT to extract and translate the articles into Spanish, and instantly publishes them as fresh posts on your WordPress site. You keep full control, with customization options like how often it checks for updates or which sheets and columns to use. The transformation is immediate—what once took hours now happens while you focus elsewhere, ensuring your site stays current and engaging, all with zero manual effort.
Ready to turn a clunky, multi-step bottleneck into a seamless automation? Follow the simple, step-by-step process in Botize, or if you’re eager to hit the ground running, use this formula directly and adapt it to your workflow with just a few clicks. Your content deserves to go live—let Botize make it happen with consistency and ease!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
Publish Fresh News in Spanish. Zero Copy-Paste.
Imagine: you drop your list of English news URLs in a Google Sheet. Reliable AI fetches each article, translates it to Spanish with the nuance only a human would expect, and publishes it straight to your WordPress blog. You’re updated and international, no manual work, no risky bots, no more lost mornings.
| Manual | Botize | |
|---|---|---|
| Find, open, and copy each news article | 3 minutes/article | 0 Minutes |
| Translate each news article | 7 minutes/article | 0 Minutes |
| Format and publish to WordPress | 4 minutes/article | 0 Minutes |
| Total | 14 minutes per article, every day—now just seconds | 0 Minutes |
Looking for a way to grab news from a spreadsheet and see them on your WordPress, beautifully translated—without wrestling with scripts or complicated tools? This is for you.
Global News Agency
You curate financial news in English, but your growing Spanish audience wants quick updates. Now, stories land in their inbox—translated and on time, without extra hires.
Automatic Publishing
New posts go live while you’re busy elsewhere.
Natural Translation
No weird robot phrases—just Spanish that connects.
Time Saver
Spend your day creating, not copy-pasting and translating.
Personal Tech Blog
You spot cool gadgets in the US media. Drop their links in Sheets, and Spanish-readers enjoy the scoop hours later on your WordPress—like you cloned yourself.
⌾︎ You manage a multilingual blog or news site and hate missing breaking stories.
⌾︎ You want your content in Spanish—without manual translation or spending on agencies.
✕ You rarely update your website and don’t care about content freshness.
✕ You only need to translate a single news piece once a year.
✓ Choose how often to check your Google Sheet—every hour, day, or instantly.
✓ Adapt the translation prompt: make it formal, casual, or aligned with your brand voice.
✓ Publish as draft or instantly live, and tag or categorize posts automatically.
This automation assumes you have a Google Sheets document where each row contains a news URL in column A. GPT will fetch each article, translate it into Spanish, and publish it as a new post in your WordPress site. The workflow should be customized to fit your specific needs.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.