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!
Automate this task with 4 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
First, we need a step that makes the automation run automatically once every hour.
Copy and paste this prompt into the AI editing tool.
Set up this automation so that it triggers itself every hour without manual input. ⤵
Click the 'Apply this task' button to confirm.
-
4
Now, let's get the next new row from our Google Sheets document, which contains the news URL in column A.
Copy and paste this prompt into the AI editing tool.
Add a step to pull the next new row from the top of Google Sheets, making sure to retrieve its columns, especially column A where the news URL is. ⤵
Click the 'Apply this task' button to confirm.
-
5
Afterwards, we want to process that URL: fetch the article, have AI translate it into Spanish, and structure the title and content for later publishing.
Copy and paste this prompt into the AI editing tool.
For the URL found in column A of the selected Google Sheets row, fetch the news article, translate both the headline and body into Spanish, and return them as 'News Title (Spanish)' and 'News Body (Spanish)'. ⤵
Click the 'Apply this task' button to confirm.
-
6
Finally, we need to publish the translated news to our WordPress site as a new post.
Copy and paste this prompt into the AI editing tool.
Take the Spanish title and body text from the last step and create a new published post on WordPress using those as the title and content. ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
