Skip to main content
Hootsuite bulk tweet upload Google Spreadsheet tool

Spreadsheet Sunday: Hootsuite Bulk Tweet Scheduler

Hootsuite is a great tool for almost any social media manager out there. It lets you manage multiple accounts and schedule social media posts across channels. Hootsuite is probably most used by marketers to help manage multiple twitter accounts and streams, and it is a great tool for doing that.

One of the power features that Hootsuite offers is bulk message scheduling via a CSV file. Bulk scheduling tweets can be a huge time saver, especially if you want to promote certain tweets or links several times throughout a month. However, creating a bulk upload sheet can be a bit of a pain with the default CSV template that Hootsuite provides.

Worry no more, you can use this simple Google Spreadsheet to help you bulk schedule your tweets with ease! Simply use the “Editor” sheet in this Google Doc and you can enter your tweet’s information. What this sheet will help you do is after you add your message and a link (if you want to include one) and this sheet will perform a character count for you to make sure your tweets are within the 140 character limit. You can also choose the time and date with ease by clicking on the little triangle in the cell and selecting the options you want from a drop down menu.

When you are ready to schedule your tweets, simply go to the “Export” sheet and export the sheet as a CSV file to upload to Hootsuite. This “Export” page automatically puts the data in the proper format for uploading to Hootsuite, so there is no extra work for you to do.

To get your own copy, click the button below, select “File” from the menu, then select “Make a copy…” to create a copy that you can use. Don’t forget to share this page with anyone who you think might find it useful!

Get It Now

728x90_landing

Adwords Ad Formating Google Spreadsheet to test the character count of PPC ads for Google Adwords

Spreadsheet Sunday: Easy Adwords PPC Ad Formatting

When you manage Google Adwords PPC ad campaigns for your self or for your clients, you know that going into Adwords can be a waste of time when all you want to do is test some new ad copy. I’ve experienced it many times myself, I know how annoying it can be to set up a new ad just to see if your character count will fit. It is especially annoying when you are proposing ads, as the client often won’t have an account or they want to see a few examples of what you might give them before the buy into it.

Your pains are no more. Use this simple Google Spreadsheet to help you format your proposed PPC ads for Adwords. Simply fill out the required lines in the Spreadsheet and it will automatically show you if you are beyond the allowed character count. As an added bonus, the ads are all formatted like they would appear on Google, so you can copy and past your ads on to another sheet and send the client a PDF of what the ads will look like!

Get Your Free Copy Of The Adwords PPC Ad Formatter

Ready to get started? Simply click a button below, make a copy of the Google Spreadsheet (File > Make a copy), and you are all set and ready to go!


Yelp listings fetcher Google Spreadsheet for local seo

SpreadSheet Sunday: Copy and Paste Yelp Competitor Info With Ease

If you handle local seo or just seo in general, you know that Yelp can be a very powerful tool to help you with competitor research. If you have ever gotten tired of going to each company’s page to get their info, you are in luck. With this new, easy to use spreadsheet you can easily copy and paste any info that you might need from your competition all in one easy place. If you can use yelp and you know how to copy and paste, there is nothing else to learn!

Here are some ideas you can use this spreadsheet for, please add your own ideas to the comments below to let others know.

  • Gathering the names and contact information of local business that compete with your company.
  • Getting a list of competitor URL’s to use for keyword and SEO research.
  • Discovering where you fit into the rankings for certain keywords
  • Discovering the number of reviews your competition has
  • Collecting the names and phone numbers of local businesses that you want to visit on a trip.

Ready to get started? Simply click the button below, make a copy of the Google Spreadsheet (File > Make a copy), and you are all set and ready to go!

Sure, I’ll Check It Out