Collect posts from a specified user on X (Twitter) every day, translate them with DeepL, and add them to Google Sheets.
Collect posts from a specified user on X (Twitter) every day, translate them with DeepL, and add them to Google Sheets.
Launch this workflow to connect
Twitter &
DeepL &
Google Sheets
!
■ Overview
Do you check posts on X（Twitter） to track the latest global insights or specific experts, but spend too much time manually translating and copying them? This workflow automates X（Twitter） + DeepL, collects posts from specified users daily, translates them, and records everything in Google Sheets—end to end. Boost the efficiency of your research process.
■ Who should use this template
- Those who regularly track overseas competitors or experts on X（Twitter）
- Those who want to connect X（Twitter） with DeepL to streamline manual translation work
- Those who want to automatically collect and log posts from specific X（Twitter） users
■ Benefits of this template
- Automatically runs collection and translation at a set time every day, so you can focus that time on other work.
- Prevents human errors like missed translations or transcription mistakes from copy-and-paste, keeping information accurate.
■ Flowbot flow
- First, connect X（Twitter）, DeepL, and Google Sheets with Yoom.
- Next, in the trigger, select the schedule trigger and set when you want the flow to start.
- In Operations, select X（Twitter） and use the 「Get a user’s posts」 action to specify the user you want to collect from.
- Then, in Operations, select DeepL and translate the fetched posts with the 「Translate text」 action.
- Next, in Operations, select the AI feature (Generate text) and create instructions（prompt） to generate any text based on the translation results.
- Finally, in Operations, select Google Sheets and, with the 「Add record」 action, add the collected posts and translations to the specified sheet.
※「trigger」：The action that starts the flow、「Operation」：The action that runs in the flow after the trigger fires
■ Customization points for this workflow
■ Customization points for this workflow
- In the schedule trigger, set any date, time, and day of the week when you want to run data collection.
- In X（Twitter）’s 「Get a user’s posts」 action, set the ID of the user you want to monitor.
- In DeepL’s translation action, you can set the target text to the post content from the previous action and change the target language (e.g., Japanese or English) from the dropdown.
- In the text generation action, enter any prompt（instruction） to generate text suited to your goal, such as summaries of the translation results or analysis of the posts.
- In the action to add a record to Google Sheets, you can configure it to add post content, translation results, and information such as execution date and time to any columns.
◾️ Notes
- Connect Yoom with each of X（Twitter）, DeepL, and Google Sheets.
- The output from X（Twitter） can be retrieved via JSONPath. For how to retrieve it, see 「How to add 『Values to retrieve』」.
Check Out Similar Templates!
Every day, exchange rate information is obtained via RPA and automatically posted on X (Twitter).
Every day, exchange rate information is obtained via RPA and automatically posted on X (Twitter). The RPA handles everything from retrieving the exchange rate information to posting it on X (Twitter), reducing the workload for the person in charge and allowing them to focus on other tasks.
Read files uploaded to Box using OCR and post them on X (Twitter).
The workflow involves automatically posting files uploaded to Box to X (Twitter) by reading them with OCR. This automates the manual text extraction and posting tasks, enhancing the efficiency of information dissemination and the accuracy of data processing.
See more
About the Apps
Twitter
Related apps
Templates using
Twitter
This is a workflow for automatically posting Notion content to Twitter. By automating regular information dissemination, you can deliver a consistent message to your followers.
A flow for automatically posting to X (Twitter) every week. By eliminating the need for manual posting, it reduces time and effort, and prevents forgetting to post or making mistakes with the day or time.
The workflow where AI analyzes emails received in Gmail and automatically posts them to X (Twitter). This reduces manual work and streamlines social media management.
DeepL
Related apps
Templates using
DeepL
After the meeting ends on Google Meet, transcribe the conversation and translate it using DeepL, then add it to Notion.
After a Google Meet meeting ends, the transcription is translated using DeepL and added to Notion. This flow streamlines the entire translation process, eliminating the need for manual translation work and enabling speedy creation of meeting minutes.
Automatically translate foreign language inquiries using DeepL and notify on Microsoft Teams.
This is a business workflow that automatically translates foreign language inquiries using DeepL and notifies Microsoft Teams. It eliminates language barriers and enables quick and accurate multilingual support.
Automatically translate the sentences of a specified document using DeepL at a specific time and share them on Microsoft Teams.
The workflow automatically translates text using DeepL at specific times and shares it on Microsoft Teams. This automates regular translation and team sharing, reducing the workload.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Twitter
Yoom allows you to integrate with X (Twitter) API without code and automate operations on X via the API. For example, you can automatically post to X by retrieving information from the web daily using RPA, or connect Google Sheets with X to collectively post information from the spreadsheet to X.
see detailsTemplates
This is a workflow for automatically posting Notion content to Twitter. By automating regular information dissemination, you can deliver a consistent message to your followers.
Automatically post Notion content to X (Twitter)
A flow for automatically posting to X (Twitter) every week. By eliminating the need for manual posting, it reduces time and effort, and prevents forgetting to post or making mistakes with the day or time.
Automatically post to X (Twitter) every week.
The workflow where AI analyzes emails received in Gmail and automatically posts them to X (Twitter). This reduces manual work and streamlines social media management.
Generate post content using AI based on emails received in Gmail and post it on X (Twitter).
DeepL
Yoom allows seamless integration with DeepL without any coding, enabling the automation of DeepL operations via API. For example, it is possible to automatically translate information received through chat tools like email or Slack, or documents created in Notion or Google Docs using DeepL.
see detailsTemplates
After the meeting ends on Google Meet, transcribe the conversation and translate it using DeepL, then add it to Notion.
After a Google Meet meeting ends, the transcription is translated using DeepL and added to Notion. This flow streamlines the entire translation process, eliminating the need for manual translation work and enabling speedy creation of meeting minutes.
After the meeting ends on Google Meet, transcribe the conversation and translate it using DeepL, then add it to Notion.
Automatically translate foreign language inquiries using DeepL and notify on Microsoft Teams.
This is a business workflow that automatically translates foreign language inquiries using DeepL and notifies Microsoft Teams. It eliminates language barriers and enables quick and accurate multilingual support.
Automatically translate foreign language inquiries using DeepL and notify on Microsoft Teams.
Automatically translate the sentences of a specified document using DeepL at a specific time and share them on Microsoft Teams.
The workflow automatically translates text using DeepL at specific times and shares it on Microsoft Teams. This automates regular translation and team sharing, reducing the workload.
Automatically translate the sentences of a specified document using DeepL at a specific time and share them on Microsoft Teams.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
New Tweet from User
When a Row Is Added
When a Row Is Updated
Flowbot operations
Create Post
Delete Post
Get User Information
Get User Posts
Get Mentions for a User
Search Recent Posts (Within the Past 7 Days)
Repost a Post
Upload Media
Prepare Media (Video) Upload
Upload Media (Video)
Complete Media (Video) Upload
Get Uploaded Media Status
Translate Text
Translate Document
Retrieve Translation Results
Set a Value in a Cell
Get Values
Clear Values
Flowbot triggers
New Tweet from User
Flowbot operations
Create PostDelete PostGet User InformationGet User PostsGet Mentions for a UserSearch Recent Posts (Within the Past 7 Days)Repost a PostUpload MediaPrepare Media (Video) UploadUpload Media (Video)Complete Media (Video) UploadGet Uploaded Media Status
Flowbot triggers
There is no action.
Flowbot operations
Translate TextTranslate DocumentRetrieve Translation Results
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
