Extract ASIN codes from Google Sheets, retrieve product details and affiliate links for each item, and publish them to a Facebook page

Stop copying, pasting, and chasing links. This automation grabs your Amazon ASINs from Google Sheets, fetches all the juicy details (with your affiliate link!), and posts them straight to your chosen Facebook Page. Effortless, every time.

Managing Amazon affiliate campaigns can feel like a never-ending chore: copying ASINs from Google Sheets, manually extracting product details, generating affiliate links, and then publishing them one by one on your Facebook page eats up hours every week. As the sheet grows, so does the risk of missing out on product launches or letting hot deals go stale before they’re online. If you don’t automate, valuable time is wasted, opportunities for affiliate earnings slip through the cracks, and your Facebook page loses the chance to stay top-of-mind with fresh, appealing product posts.

This Botize formula seamlessly connects your Google Sheets, Amazon Associates API, and Facebook page into a single, automated pipeline. Every hour—or any interval you choose—it fetches the next ASIN from your sheet, retrieves optimized product data and your affiliate link, and instantly publishes an engaging post with images and details on your Facebook page. No more repetitive copy-pasting or missed updates: your affiliate content pipeline transforms into a set-and-forget engine that keeps your audience engaged, your brand visible, and your earnings potential on autopilot.

Ready to break free from tedious manual work? Try out this formula and follow the step-by-step guidance to get it running—no coding, no headaches. You can fine-tune the frequency, choose which sheet/rows to use, and match the posts to your Facebook strategy. Dive in with Botize and let your affiliate marketing truly work for you, not the other way around!

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.

Customize and save

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

Turn Amazon Products in Your Sheet Into Viral Facebook Posts — Automatically

Here’s how it works: you toss your Amazon ASINs into a plain ol’ Google Sheet. Each hour, magic happens — the automation reads the next product, pulls all its info from Amazon (including your affiliate link), and posts the product to your Facebook page. Rinse, repeat, smile.

	Manual	Botize
Copy ASIN from sheet to Amazon	1	0 Minutes
Get product details and save image	3	0 Minutes
Generate affiliate link	2	0 Minutes
Draft and post to Facebook page	4	0 Minutes
Total per post	10	0 Minutes
Total per 20 products	200	0 Minutes

Yep, you’re in the right place — this is the easy, human-friendly way to turn your Amazon product list into Facebook posts (and earnings), with zero manual work.

Start for Free and See It in Action

Affiliate Marketer Boost

Emma used to post products manually. Now her Facebook page is updated every day, automatically, with her affiliate links. More clicks, more commission, less stress.

Zero Repetitions

No more manual copy-paste madness — do it once and lean back.

Automatic Monetization

Your affiliate links, every time, no missed opportunity.

Consistent Presence

Keep your Facebook page active, even while you sleep (or nap, we don’t judge).

E-commerce Social Proof

Javier runs a gadget review group. His sheet collects cool Amazon finds, and this automation does all the posting like clockwork — letting him focus on engaging with his community.

🚀

⌾︎ You regularly post Amazon products on Facebook and want that sweet affiliate commission.

⌾︎ You manage pages, groups, or communities that fizzle out when you get too busy.

🙅‍♂️

✕ You never use Google Sheets or Facebook Pages and don’t want to start.

✕ You prefer to post every item manually and love wasting time.

✓ Choose how often the posts appear (every hour, daily, you name it).

✓ Tweak the message template to match your brand’s voice and flair.

✓ Connect any Facebook Page you manage — or several, if you’re ambitious!

I Want My Time (and Commissions) Back

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.