One-way sync between Telegram, Notion, Google Drive, and Google Sheets
Who is this for?
This workflow is perfect for productivity-focused teams, remote workers, virtual assistants, and digital knowledge managers who receive documents, images, or notes through Telegram and want to automatically organize and store them in Notion, Google Drive, and Google Sheets—without any manual work.
What problem is this workflow solving?
Managing Telegram messages and media manually across different tools like Notion, Drive, and Sheets can be tedious. This workflow automates the classification and storage of incoming Telegram content, whether it’s a text note, an image, or a document. It saves time, reduces human error, and ensures that media is stored in the right place with metadata tracking.
What this workflow does
- Triggers on a new Telegram message using the Telegram Trigger node.
- Classifies the message type using a Switch node:
- Text messages are appended to a Notion block.
- Images are converted to base64, uploaded to imgbb, and then added to Notion as toggle-image blocks.
- Documents are downloaded, uploaded to Google Drive, and the metadata is logged in Google Sheets.
- Sends a completion confirmation back to the original Telegram chat.
Setup
- Telegram Bot: Set up a bot and get the API token.
- Notion Integration:
- Share access to your target Notion page/block.
- Use the Notion API credentials and block ID where content should be appended.
- Google Drive & Sheets:
- Connect the relevant accounts.
- Select the destination folder and spreadsheet.
- imgbb API: Obtain a free API key from imgbb.
Replace placeholder credential IDs and asset URLs as needed in the imported workflow.
How to customize this workflow to your needs
- Change Storage Locations:
- Update the Notion block ID or Google Drive folder ID.
- Switch Google Sheet to log in a different file or sheet.
- Add More Filters:
- Use additional Switch rules to handle other Telegram message types (like videos or voice messages).
- Modify Response Message:
- Personalize the Telegram confirmation text based on the file type or sender.
- Use a different image hosting service if you don’t want to use imgbb.