Create your own Pinterest scheduling spreadsheet or use my free Pinterest scheduling spreadsheet to increase your blog traffic, repins, and followers! This post contains my Tailwind affiliate link in case you want to sign up, but they’re not paying me for or sponsoring this post in any way.
A couple of months ago I wrote a post about why I love using Tailwind for Pinterest scheduling and in that post, I promised that I would share how I use Tailwind to schedule a month worth of pins in about an hour. Then life got in the way, so this is part 1 of that post – getting started by creating a master Pinterest spreadsheet. Using this method of pin scheduling seriously saves me so much time. All of the time that I used to spend scheduling out individual pins can now be used on more productive things like planning summer parties.
The master Pinterest scheduling spreadsheet has been the absolute key to saving time with Pinterest scheduling through Tailwind. It takes quite a bit of work to get it setup in the first place but once it’s setup, it is seriously a game-changer.
If you’d rather not create the spreadsheet yourself, you can get a copy of my master Pinterest scheduling spreadsheet by subscribing to my email newsletter and checking the box to receive my Pinterest spreadsheet. If you’re already subscribed to my newsletter, send me an email with the email you’re subscribed with, and I’ll send it to you manually. I can’t help you fill in the blanks, but it’ll at least save you time creating the spreadsheet.
Step 1 – Create a group boards tab in the spreadsheet with information about your group boards. Mine includes:
- Group board name
- Number of followers
- What can be pinned to that board (e.g., recipes, crafts, anything)
- Any other rules for that board (e.g., only pin once, limit to 5 pins a day)
Step 2 – Create a pin schedule tab in the spreadsheet that includes:
- Post title
- Post URL
- Most repinned pin link for that post (I just found this by looking through Pinterest or Tailwind analytics)
- Pin category – I’ve decided all of my posts into a handful of categories that make sense to me for bulk scheduling. I have categories that correspond with different group board categories like appetizers, comfort foods, desserts, printables, home decor, gifts, party, and lifestyle posts.
- Pin score (leave blank for now, I fill this in as part of my Pinterest scheduling routine)
- Last scheduled (leave blank for now, I fill this in as part of my Pinterest scheduling routine)
- Unique page views (not necessary, I just like to update this about once a month to see if my Pinterest scheduling is bringing traffic)
- Number of pins (not necessary, I just like to update this about once a month to see if scheduling is helping with repins)
- Post type – basically is this an evergreen or seasonal post and if it’s seasonal, which season. I hide any posts that aren’t in the season I’m in so I have less to work with at one time.
And then to the right of all that information, copy and paste special (transpose) your list of group board names. I used colors to categorize my group boards based on size (and how frequently I pin each post to them). I have four different categories of group boards –
- Red – Huge group boards that I can pin posts to monthly because the pins move so fast. These are boards like DIY boards, Crafty 2 the Core, etc.
- Blue – Medium group boards that I can pin posts to often but not every month. These are boards that have less than 100,000 followers.
- Purple – Small group boards (less than 20,000 followers) that I only post seasonal things to once or twice during the season and evergreen posts once every few months.
- Green – Post once group boards; these have a rule that you can only pin each post once.
Step 3 – Go through and fill in the information for all of your posts. This is a huge step but so helpful once you have it done. As I write new posts, I just add the new post information to the end of the spreadsheet and fill in all of the details I can.
Step 4 – Create a new tab for “bad or need to be updated posts.” As you’re going through and putting together the pins and post information for each of your posts, this is a perfect time to pull out posts that need new pinnable images, aren’t pinning well, or just need a little sprucing up. I like to pin my best posts, so I pull any “bad posts” out and put them on this tab so I can deal with them separately. Once I’ve updated them, I add them back into the main spreadsheet to test. You can read more about how I do this in my Pinterest scheduling post.
And that’s it! If you have a lot of posts, this will probably take you a good amount of time, but you can easily delegate parts of it like getting all of your post URLs and pins to a VA or intern since it’s mostly just data entry. And it’s so worth it when you’re done. Having a master Pinterest spreadsheet lets me schedule a month worth of pins using Tailwind in literally less than an hour.
If you don’t want to do all of the work yourself, you can get a copy of my master Pinterest scheduling spreadsheet by subscribing to my email newsletter and checking the box to receive my Pinterest spreadsheet. If you’re already subscribed to my newsletter, send me an email with the email you’re subscribed with, and I’ll send it to you manually.