Detect each new post in a third-party Telegram chat, modify any Amazon affiliate links it contains, and save it to Google Sheets

Let your favorite Telegram groups fill your wallet, not just your feed. Instantly transform Amazon affiliate links—even from third-party chats—and save them all to Google Sheets without lifting a finger.

  • Instantly when the trigger is activated
  • Instantly when receiving a text message in a chat (telegram_channels → webhook_all)
  • Modify the affiliate URLs in a text (amazon_lightning → replace_text_urls)
  • Check if meets specific conditions (btzfilters → process)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

Juggling affiliate links from multiple Telegram chats is a tedious nightmare—constantly monitoring discussions, copying messages, manually swapping out someone else’s Amazon affiliate codes for your own, and pasting results into a spreadsheet. This repetitive grind wastes hours every week, invites slipups that cost you referral income, and makes scaling your affiliate strategy almost impossible. If you don’t automate, you keep bleeding time, lose commissions to competitors, and miss out on data clarity that could be driving your growth.

This Botize formula will transform the chaos into order by automatically detecting every new message in your chosen third-party Telegram chat—using your user account for seamless access—then searching for Amazon affiliate links, substituting your unique tag for theirs, and recording the clean, optimized post in Google Sheets. You’re always in control: pick exactly which chat to watch, set your custom Amazon tag, filter only affiliate-containing messages, and update everything in real-time. The result? No more missed revenue, error-free tracking, and all your optimized links organized in a single source that’s ready for exploitation or analysis.

Ready to reclaim your time and maximize every Amazon mention with zero manual labor? Follow the step-by-step below to set up this automation exactly how you want—or jump ahead by using this Botize formula where all the pieces are pre-arranged for you. Tap into ultimate efficiency and never leave an affiliate dollar behind.

Automate this task with 5 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Set up the initial trigger for the automation so it starts working as soon as a new message is available.

    Copy and paste this prompt into the AI editing tool.

    Create a trigger that activates instantly to start the automation when a new event happens.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Detect when a new text message is posted in a specific Telegram chat.

    Copy and paste this prompt into the AI editing tool.

    Add a step to monitor a chosen Telegram chat and instantly detect any new text message posted there.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Change any Amazon affiliate link in the message text to use your own affiliate code.

    Copy and paste this prompt into the AI editing tool.

    Take the text from the new Telegram message and replace any Amazon affiliate links with the affiliate tag you specify.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Make sure only messages with changed links are processed further, to avoid unnecessary actions.

    Copy and paste this prompt into the AI editing tool.

    Add a filter that checks if the affiliate link in the text was actually modified. Only continue if the link was changed.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Save the modified message with the updated affiliate link into your chosen Google Sheets spreadsheet.

    Copy and paste this prompt into the AI editing tool.

    Add a step to append the updated message as a new row in a Google Sheets document you select.

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Catch Every Amazon Deal & Never Miss a Commission Again

Here’s how it works: Your Telegram account quietly keeps an eye on any group you want. Any new message with Amazon affiliate links gets snapped up, swapped for your personal affiliate code, and organized in Google Sheets before you can say ‘ka-ching’. You only need to set your chat, set your tag, and let the magic do the rest. Simple, bold, and surprisingly satisfying.

Manual Botize
Spotting Amazon links in chat manually 15 minutes/day 0 Minutes
Replacing affiliate codes one by one 10 minutes/day 0 Minutes
Organizing links into a spreadsheet 15 minutes/day 0 Minutes
Total 40 minutes/day 0 Minutes

If you've been copy-pasting Amazon links from Telegram and wishing they used your affiliate tag: Stop! This is *exactly* what you've been searching for.


Community Admin Power-Up

Maria manages three Telegram groups for deal hunters. With this automation, she seamlessly earns from every Amazon link posted—by anyone—without spamming or hassle.

Zero Missed Links

Every Amazon link—spotted, swapped, and logged, automatically.

Stealth Mode

Works as you (not a bot), so you never risk bans or weird errors.

Effortless Records

All your affiliate grabs perfectly organized in Google Sheets.


Solo Affiliate Side Hustle

Carlos follows three top product chats. He uses this system to catch, rebrand, and track every hot item link for his own blog and Twitter alerts—all in one sheet.

🚀

⌾︎ This system is ideal if you love sharing Amazon deals but hate missing out on commissions.

⌾︎ It’s perfect if you track, monetize, or analyze affiliate links from group chats—no matter how busy.

✕ Not useful if you don't use Telegram or work with Amazon affiliate links.

✕ Doesn’t make sense if you only want bot-powered automations and never need to personalize.


✓ Choose any Telegram group, channel, or even secret chat you have access to.

✓ Set your affiliate tag for different Amazon regions for global reach.

✓ Link as many Google Sheets as you want—filter, sort, or share your records instantly.




This automation is designed to copy content from a third-party chat using your Telegram user account instead of a bot, assuming the messages contain Amazon affiliate links. The task replaces those links with the ones from the Amazon account you specify and then saves the result to a Google Sheets spreadsheet. You will need to edit the task to specify the source chat, your Amazon affiliate tag, and the destination chat.

Related automations