Extract ASIN codes from Google Sheets, retrieve product details and affiliate links for each item, and publish them to a Facebook page and Pinterest
No more copy-pasting ASINs, fetching images, or manually sharing each affiliate link. Let your Google Sheet handle your social feeds — automatically.
Struggling to share your latest Amazon products on Facebook and Pinterest? Manually copying ASINs, hunting for affiliate links, and creating posts for every single item is draining your time and energy—and if you’re not keeping up, you’re missing out on valuable commissions, exposure, and engagement. Without automation, your affiliate marketing efforts stall, your content pipeline dries up, and competitors who move faster start crowding out your posts online.
This formula completely transforms your workflow. Every hour, Botize reads the next Amazon ASIN from your Google Sheet, fetches all the rich product details and your personalized affiliate link straight from Amazon, then automatically crafts and publishes eye-catching posts to both your Facebook page and Pinterest account. Forget repetitive copying and pasting: your feed stays consistently fresh, your affiliate links are always live, and you never miss an opportunity to monetize—a true set-it-and-forget-it system. You retain full control over post frequency, easily change which Facebook page or Pinterest board to use, and can filter or batch products for ultimate flexibility.
Ready to stop wasting hours on manual posting and start maximizing your affiliate reach? Just follow the step-by-step guide to set up this formula in minutes, or use the ready link to launch it instantly. Liberate your marketing, boost your income, and be everywhere your audience expects you—effortlessly!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
Automate Amazon Product Publishing to Facebook & Pinterest in One Click
Just drop your Amazon ASIN codes into Google Sheets. Each hour, we’ll pick the next item, fetch its details (picture, title, price, even your affiliate link), and post a beautiful update to your chosen Facebook page and Pinterest board. No ‘hacks’. No browser extensions. Just pure, hands-off publishing.
| Manual | Botize | |
|---|---|---|
| Look up product details (title, image, price) | 3 minutes | 0 Minutes |
| Create affiliate link | 2 minutes | 0 Minutes |
| Write and format a Facebook post | 3 minutes | 0 Minutes |
| Create and publish a Pinterest Pin | 4 minutes | 0 Minutes |
| Switch between tabs, copy-paste, update sheets | 3 minutes | 0 Minutes |
| Total | 15 minutes per product | 0 Minutes |
Yes, you’re in the right place. If wasting time on spreadsheets and social media is driving you crazy, this is your shortcut.
The Niche Marketer
Maria manages a Facebook page about kitchen gadgets. She fills a Google Sheet with ASINs, then kicks back while her page stays updated daily with new Amazon affiliate products, each with her link.
Zero Manual Posting
Never again download images or paste URLs — every step runs itself in the background.
Affiliate Earnings, Faster
Get your products out there with your affiliate links — automatically, every hour, even while you sleep.
Consistent Presence
Keep your Facebook and Pinterest fresh and active without lifting a finger.
List Building for Pinterest
Jorge curates deals for tech gear. His Google Sheet triggers fresh Pins every hour, building a highly active Pinterest board linked right to his affiliate links.
⌾︎ You’re an Amazon Associate who loves automation and wants to scale marketing without extra effort.
⌾︎ You manage Facebook Pages or Pinterest boards and want reliable, drip-feed posting of curated products.
✕ You want to do 100% manual curation and write unique posts for each product.
✕ You don’t use Google Sheets or don’t care about Facebook or Pinterest traffic.
✓ Easily change the posting interval — post every 10 minutes, hourly, or just once a day.
✓ Pick which columns in your Google Sheet control which social post field (title, image, pricing, etc).
✓ Tailor the Facebook or Pinterest message templates to match your brand voice, emoji, or style.
This automation, each time it runs, extracts the next product from a Google Sheets file. It assumes that column A contains the ASIN codes of Amazon products. The automation retrieves product details using the official Amazon API. It then publishes the product with your affiliate link on the Facebook page you specify and Pinterest.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.