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!
Automate this task with 4 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 automatically on a regular schedule.
Copy and paste this prompt into the AI editing tool.
Set up the automation to run every hour, so it checks for a new product to process at that interval. ⤵
Click the 'Apply this task' button to confirm.
-
4
Now, we need to get the next product to process from the Google Sheets file.
Copy and paste this prompt into the AI editing tool.
Add a step that extracts the next row from Google Sheets, where each row contains an Amazon ASIN code in column A. ⤵
Click the 'Apply this task' button to confirm.
-
5
After getting the ASIN, let's fetch the product information and affiliate link from Amazon.
Copy and paste this prompt into the AI editing tool.
Use the ASIN from the Google Sheet to look up product details and affiliate links using the official Amazon Associates API. ⤵
Click the 'Apply this task' button to confirm.
-
6
Finally, share the product on Facebook with its details and your affiliate link.
Copy and paste this prompt into the AI editing tool.
Create a post on your specified Facebook Page that includes the product's title, price info (including savings, if available), and the affiliate link you got from Amazon. ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
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!
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.
