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!
Automate this task with 5 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Start by making sure the automation runs regularly to check for new products.
Copy and paste this prompt into the AI editing tool.
Set up the automation to run automatically every hour. ⤵
Click the 'Apply this task' button to confirm.
-
4
Retrieve the next product's ASIN code from your Google Sheets file (column A).
Copy and paste this prompt into the AI editing tool.
Add a step to pull the next unused row from column A in your Google Sheet, as this contains the product ASIN code. ⤵
Click the 'Apply this task' button to confirm.
-
5
Get product details from Amazon using the ASIN code you just pulled.
Copy and paste this prompt into the AI editing tool.
Use the Amazon API to look up the product by its ASIN code and fetch details like the title, price, images, product URL with your affiliate link, and any discounts. ⤵
Click the 'Apply this task' button to confirm.
-
6
Share the product on your Facebook page with all the important details.
Copy and paste this prompt into the AI editing tool.
Create a post on your selected Facebook page, including the product title, price (show discounts if available), and your Amazon affiliate link. ⤵
Click the 'Apply this task' button to confirm.
-
7
Publish the product on Pinterest to reach a wider audience.
Copy and paste this prompt into the AI editing tool.
Create a Pinterest Pin using the product's image, title, any applicable discount, the current price, and your affiliate link. ⤵
Click the 'Apply this task' button to confirm.
-
8
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
