Free Script Pinterest Automatic Pin with Imacros for Begginer

If previously I wrote an article about Script auto tweet with Imacros and Tweetdeck , This time I will share about Pinterest Automatic Pin with Imacros. With this tools, we can automatic pin our blog post to pinterest board. Using iMacros, we no longer need bother to market our amazon affiliate product on social media like pinterest.

 Boost your amazon earning with Pinterest Automatic Pin .

Besides observant in choosing a product, marketing is also necessary to increase our earnings. Source of Traffic and earnings for my amazon affiliate site, most are from pinterest. Why use Pinterest ? Pinterest helps people discover the things they want to plan, buy and do. Here’s how it works for you ( read here ).

Let`s start the experiment

1. The Pin It button Formatted Url



?url=http%3A%2F%2Fwww.flickr.com%2Fphotos%2Fkentbrew%2F6851755809%2F
&media=http%3A%2F%2Ffarm8.staticflickr.com%2F7027%2F6851755809_df5b2051c9_z.jpg
&description=Next%20stop%3A%20Pinterest

With the following information :

  • Url , your blog post url.
  • Media, your product`s picture url.
  • Description, your product description.

Learn more about pinterest here ( Pin It button ).

2.  How do we get the blog`s data ?

Many ways to get post`s data. In this case, i use mysql query to get my amazon product post and data. this is example how i get my blog post from Phpadmin ( My wordpress database was modified).


SELECT d.name,CONCAT( "http://www.pinterest.com/pin/create/button/
?url=http://mysite.com/", a.post_name,
"&media=", e.meta_value, "&description=",
SUBSTR( a.post_title, 1, 250 ) ,
 " on http://mysite.com/", a.post_name ) AS result
FROM wp_posts a
INNER JOIN wp_term_relationships b ON a.ID = b.object_id
INNER JOIN wp_term_taxonomy c ON b.term_taxonomy_id = c.term_taxonomy_id
INNER JOIN wp_terms d ON c.term_id = d.term_id
INNER JOIN wp_postmeta e ON a.ID = e.post_id
WHERE a.post_status = 'publish'
AND c.taxonomy = 'category'
AND e.meta_key = 't_image'
AND LENGTH( CONCAT( SUBSTR( post_title, 1, 250 ) , " on http://mysite.com/", post_name ) ) <=498
ORDER BY d.name, post_date ASC

In my case, i export query data into CVS format. The format will be like below

pinterest automatic pin

3. You need to create the pinterest board first.

Okay, after we get data (save your data to c:\data.csv ) , create imacros script pinterest automatic pin.


VERSION BUILD=8810214 RECORDER=FX
TAB T=1
SET !DATASOURCE C:\data.csv
SET !LOOP 1
SET !DATASOURCE_LINE {{!LOOP}}
URL GOTO={{!COL2}}
TAG POS=1 TYPE=LI ATTR=TXT:{{!COL1}}
WAIT SECONDS=5
TAG POS=1 TYPE=BUTTON FORM=NAME:NoFormName ATTR=TXT:Pin<SP>it
WAIT SECONDS= 30

 That is Script Pinterest Automatic Pin with Imacros or you can download the script below

If the above script can not work properly anymore, please use my new iMacros script for auto pin pinterest on the following article

The following two tabs change content below.
This site is a personal Blog of Sigit Prasetya Nugroho, a Desktop developer and freelance web developer working in PHP, MySQL, WordPress.

7 Comments

 Add your comment
  1. Excellent pieces. Keep writing such kind of ifo on your page.
    Im really impressed by your blog.
    Hi there, You have dne a great job. I will certainly digg iit annd in my ooinion recommmend to
    my friends. I’m sure they will be benefited from this web site.

  2. RuntimeError: Column number 2 greater than total number of columns 1, line 6 (Error code: -953)

  3. Hi guys,

    First – good job with the script and the site.

    Quick suggestion – Pintereste changed lately their pin pop-up and introduced a “Recently Picked” selection of 3 pinboards on top of the pinvboard list – this broke the iMacro script.

    Is there any way you can update the script please?

    John

  4. Thanks Sigit,
    I appreciate it.

    I believe it’s the same issue as the one reported by Müslüm.
    Anyway, thanks for your help. I appreciate it.

    John

  5. Mature Women 35 Plus

    Thanks for share , it work for me .

Leave a Comment

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.

%d bloggers like this: