Generate Weekly French Scenarios
Generate a B1-level French roleplay scenario every Saturday, log it to Google Sheets, and send a practice prompt via Telegram for learners.
Weekly French Scenario Generator
This workflow automatically creates a fresh French roleplay scenario every week, specifically designed for B1 (intermediate) French language learners. It generates a realistic and accessible scenario, logs it to a Google Sheet for reference, and sends a practice prompt via Telegram so learners can jump right in.
What It Does
- Triggers every Saturday at 9:00 AM (Istanbul / CET time) to kick off scenario generation.
- Uses an AI agent to produce a B1-level roleplay scenario — including context, character roles, vocabulary with translations, sample dialogue, and a grammar tip.
- Saves the scenario to a Google Sheets document so you can track and review past scenarios.
- Sends a friendly Telegram message with a short introduction and vocabulary hints, inviting learners to start practicing immediately.
Tip: This workflow pairs well with a separate Telegram Roleplay Bot workflow that lets learners chat interactively with an AI in the roleplay scenario.
What You Need
- A Needle platform account to run the workflow.
- AI model access enabled on Needle (the workflow uses an AI node to generate scenarios).
- A Google account with a Google Sheets spreadsheet set up for storing scenarios.
- A Telegram bot token and chat ID to send messages.
How the Flow Works
| Step | Node | Description |
|---|---|---|
| 1 | Scheduled Trigger | Fires every Saturday at 9:00 AM Istanbul time to start the flow. |
| 2 | AI Node | Generates a French B1-level roleplay scenario with setting, roles, vocabulary, dialogue starters, and a grammar tip. |
| 3 | Google Sheets Upsert Row | Inserts or updates the scenario details into a dedicated spreadsheet for tracking. |
| 4 | Code Node | Formats a friendly Telegram message with the scenario introduction and vocabulary hints. |
| 5 | HTTP Request | Sends the formatted message to the Telegram chat via the bot API. |
Google Sheets Structure
The spreadsheet should be set up with the following columns:
| Column | Content |
|---|---|
| A | Date |
| B | Scenario Title (French) |
| C | Scenario Title (English) |
| D | Setting |
| E | Role 1 |
| F | Role 2 |
| G | Vocabulary |
| H | Dialogue Starter |
| I | Grammar Tip |
Make sure you create this spreadsheet in your Google account and connect it to the Google Sheets node before activating the workflow.
Output
At the end of each run, you get:
- A freshly generated intermediate-level French roleplay scenario stored in Google Sheets.
- A Telegram message prompting you to start practicing directly from your phone or computer.
Notes
- Vocabulary and grammar are carefully tailored to B1 learners — no advanced structures or uncommon words.
- The Telegram message uses a warm, conversational tone to encourage interactive practice.
- You can customize scenario themes by adjusting the AI prompt, or change the schedule by editing the trigger node.
- Make sure your Google Sheet's worksheet ID is set as the integer
0(not the string"0") for the upsert to work correctly. - Remember to replace the placeholder Telegram bot token and chat ID with your own credentials before activating the workflow.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.