Extract each row from a Google Sheets containing products, create a message with the cell values, and post it on Telegram

Turn your Google Sheets data into engaging Telegram posts effortlessly.

  • Execute the task periodically
  • Extract the next new row (gspreadsheet → read_row)
  • Send a message (telegrambot → send_message_photo)

Managing a catalog of products on Google Sheets and keeping your Telegram audience up to date is no small feat. Every time you manually copy product details, adjust prices, hunt down links and images, and craft a post, you lose valuable time—sometimes hours each week, especially if your product list is large or frequently changing. Not only is this tedious, but delays and missed updates mean lost sales, diminished audience engagement, and a real risk of competitors getting ahead while your offers sit unseen.

This Botize formula connects your Google Sheets with Telegram and takes care of everything for you, automatically extracting each row—complete with product title, new and old pricing, affiliate link, and image—then creating an attractive, actionable message every hour (or at your chosen frequency). No more manual copy-pasting, no risk of missing a hot offer. Set your own posting intervals, filter which products to share, and always stay in sync with the freshest deals. Just set it and watch your Telegram channel fill up with perfectly formatted product posts that boost both visibility and revenue—without lifting a finger.

Ready to transform the way you promote your products? Let’s walk through setting up this automation in Botize—customize the timing, choose your filters, and start showcasing your products to the world in minutes. Or, if you prefer, jump ahead to use the ready-to-go formula and see instant results. Your smarter, faster workflow starts now!

Automate this task with 3 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

    Start by making sure this automation runs automatically on a regular schedule.

    Copy and paste this prompt into the AI editing tool.

    Set up the automation so that it triggers every hour. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Now, add a step to get information about each product from your Google Sheets file.

    Copy and paste this prompt into the AI editing tool.

    Extract the next new row from the first sheet in your Google Sheets, skipping the header row, and get the values for: Product Title (Column A), Current Price (Column B), Previous Price (Column C), Affiliate URL (Column D), and Image URL (Column E). ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Finally, share each product as a message on Telegram, including the key details and a button.

    Copy and paste this prompt into the AI editing tool.

    Create a Telegram message with: the product title, the current and previous prices with the appropriate currency symbol, and attach the image from the Image URL. Add a button labeled 'Ver producto' that links to the affiliate URL. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

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

    Save changes

Simplify Your Product Updates

Effortlessly extract product details from Google Sheets and share them on Telegram. Just set it up and watch the magic happen.

Manual Botize
Compiling product information 30 0 Minutes
Creating Telegram posts 20 0 Minutes
Total 50 0 Minutes

Looking to make product sharing a breeze? You’ve hit the jackpot!


E-commerce Updates

A small online store uses this to send new product updates to their dedicated Telegram channel, increasing customer engagement.

Ease of Use

No need for coding skills. Just plug and play.

Time Saver

Transforms hours of work into minutes with automation.

Consistent Updates

Keep your audience engaged with regular updates.


Flash Sales Alerts

A business alerts its followers about time-sensitive discounts with instant Telegram updates, driving quick sales.

đź”–

⌾︎ Ideal if you want to keep your Telegram community updated with product info.

⌾︎ Perfect if you manage multiple products and need an efficient way to share details.

⚠️

âś• Not useful if you don't use Google Sheets for product management.

âś• Won't benefit those who don't use Telegram for communication.


âś“ Adjust the frequency of updates to fit your schedule.

âś“ Personalize the Telegram message style to reflect your brand.

âś“ Include extra columns in Google Sheets to add more details.




This task assumes that you already have or will create a Google Sheets spreadsheet where there is one product per row with the following structure: Product Title (Column A), Current Price (B), Previous Price (C), Affiliate URL (D), Image URL (E)

Related automations