Create Google My Business POSTS with our Google Sheets Add-on
We built this Add-on to help you create, and schedule Google My Business - POSTS with the ability to schedule posts in the future, and also use a consistent tagging scheme along the way.
This tool allows you to easily create and publish Google My Business (GMB) Posts through the GMB API. This allows you easily create posts for multiple locations easily and efficiently, all in one easy to use interface that you already use every day: Google Sheets.
You can easily set up scheduling of posts far out into the future so you can sit down and efficiently build a GMB Campaign out into the future.
The tool also comes with utm tagging baked in. This means that you will efficiently and consistently deliver data to google analytics that makes it easy to track the effectiveness of your posts. You'll know whic type of post was responsible for engagement and which specific post was responsible for goal completions like filling out a lead form, or a purchase on an ecommerce site.
Explainer Video
How to use the AgencyAutomators Posts Tool
This manual goes over the functionality
Setup
Click Add-ons Menu > AgencyAutomators - Posts > Run Initial Setup. Setup takes 5 - 10 Seconds to build the Tool.
Configuring the Tool
Get Locations
Click the Add-ons Menu > AgencyAutomators - Posts > Get locations to pull in all
the GMB locations associated with the account you just selected.
Setting up Auto Posting
Click the Drop-down arrow in CONFIG Tab Cell A4
and select the hour range that you want the tool to run each day.
Click Add-ons Menu > AgencyAutomators - Posts > Turn On daily posting
How does daily Google My Business posting work?
Magic!
Seriously though, the tool will check each day at the time you set above and if any posts have the Publish Date (Column B on the GMB Posts Tab) matching today's date, the post get's published.
How do I turn off daily posting?
Click Add-ons Menu > AgencyAutomators - Posts > Turn Off daily posting
Creating Posts
You can set up 4 types of Posts using this tool: Call to Action (CTA), Event, Offer, and Alert.
Here's how to set up each type.
What's new Posts
A call to action post is the basic form of a Google Post. It gives you the ability to set an image or video, a summary of up to 1500 characters (with 100 - 300 characters being the advised length), and a Call to action for users to act upon.
To set up a CTA post, do the following:
Publish Date (A Column in YYYY-MM-DD format) - Set the date you want the post to publish.
Location (B Column) - Click the dropdown and pick the appropriate location.
Post Type (C Column) - Set to What's new
UTM Content (D Column) - Set to a one to two word phrase that will be unique and easy to match to the specific post you make.
Summary (E Column) - Type your Post body content here. Each post can have up to 1500 characters but the recommended length is between 150 - 300 characters
Media Type (F Column) - Click the dropdown and pick either image or video.Image size dimensions: images should have a 4:3 ratio with a range of 480 x 270 up to 2120 x 1192 with 1024 x 576 as the recommended size.
Media URL (G Column) - Enter the URL where the media lives online.
CTA Type (H Column) - Click the dropdown and pick the CTA you want your users to see.
CTA URL (I Column) - Enter the URL where you want to user to to to when they click the CTA.
Event Posts
An Event post allows you to create a post that promotes an event. It gives you the ability to set an image or video, a summary of up to 1500 characters (with 100 - 300 characters being the advised length), and event Details.
To set up an event post, do the following:
Publish Date (A Column in YYYY-MM-DD format) - Set the date you want the post to publish.
Location (B Column) - Click the dropdown and pick the appropriate location.
Post Type (C Column) - Set to What's new
UTM Content (D Column) - Set to a one to two word phrase that will be unique and easy to match to the specific post you make.
Summary (E Column) - Type your Post body content here. Each post can have up to 1500 characters but the recommended length is between 150 - 300 characters
Media Type (F Column) - Click the dropdown and pick either image or video.Image size dimensions: images should have a 4:3 ratio with a range of 480 x 270 up to 2120 x 1192 with 1024 x 576 as the recommended size.
Media URL (G Column) - Enter the URL where the media lives online.
CTA Type (H Column) - Click the dropdown and pick the CTA you want your users to see.
CTA URL (I Column) - Enter the URL where you want to user to to to when they click the CTA.
Title (J Column) - Enter the Event's Title here in 4-5 words. This field has a 58 character maximum length.
Start Date (K Column in YYYY-MM-DD format) - Double click the cell an pick the date the Event begins.
Start Time (L Column in HH:MM 24 hour format) - enter the event's start time in 24 hour time.
End Date (M Column in YYYY-MM-DD format) - Double click the cell an pick the date the Event ends.
End Time (N Column in HH:MM 24 hour format) - enter the event's end time in 24 hour time.
Offer Posts
An Offer post allows you to create a post that promotes an Offer. It gives you the ability to set an image or video, a summary of up to 1500 characters (with 100 - 300 characters being the advised length), and offer /event Details.
To set up an offer post, do the following:
Publish Date (A Column in YYYY-MM-DD format) - Set the date you want the post to publish.
Location (B Column) - Click the dropdown and pick the appropriate location.
Post Type (C Column) - Set to What's new
UTM Content (D Column) - Set to a one to two word phrase that will be unique and easy to match to the specific post you make.
Summary (E Column) - Type your Post body content here. Each post can have up to 1500 characters but the recommended length is between 150 - 300 characters
Media Type (F Column) - Click the dropdown and pick either image or video.Image size dimensions: images should have a 4:3 ratio with a range of 480 x 270 up to 2120 x 1192 with 1024 x 576 as the recommended size.
Media URL (G Column) - Enter the URL where the media lives online.
CTA Type (H Column) - Click the dropdown and pick the CTA you want your users to see.
CTA URL (I Column) - Enter the URL where you want to user to to to when they click the CTA.
Title (J Column) - Enter the Event's Title here in 4-5 words. This field has a 58 character maximum length.
Start Date (K Column in YYYY-MM-DD format) - Double click the cell an pick the date the Event begins.
Start Time (L Column in HH:MM 24 hour format) - enter the event's start time in 24 hour time.
End Date (M Column in YYYY-MM-DD format) - Double click the cell an pick the date the Event ends.
End Time (N Column in HH:MM 24 hour format) - enter the event's end time in 24 hour time.
Coupon Code (O Column) - Enter the Code users have to use to Redeem the Offer.
Redemption URL (P Column) - Enter the URL the User has to Go to to Redeem the Offer.
Terms and Conditions (Q Column) - Enter any applicable Terms and conditions for the User to Redeem the Offer.
COVID-19 Alert Posts
Publish Date (A Column in YYYY-MM-DD format) - Set the date you want the post to publish.
Location (B Column) - Click the dropdown and pick the appropriate location.
Post Type (C Column) - Set to Alert
Summary (D Column) - Type your Alert Post body content here. Each post can have up to 1500 characters,
but the recommended length is between 150 - 300 characters.
Alert Type (R Column) - Click the dropdown and pick the appropriate Alert Type
including COVID_19 which will post a special COVID-19 ALert Type.
Uploading Posts
Click the Add-ons Menu > AgencyAutomators - Posts > Upload Posts
The tool will then loop through all the posts in the sheet and upload to Google any of the posts with Today's date in Column B and that does not have "uploaded in Column A already.
UTM Customization for Google My Business Posts
Campaign Source - Set to google by default.
Campaign Medium - Set to organic by default.
Campaign Name - CTA / What's New Post - Set to gmb-whats-new-post by default.
Campaign Name - Event Post - Set to gmb-event-post by default.
Campaign Name - Offer Post - Set to gmb-offer-post by default.
Campaign Name - Alert - Set to gmb-alert-post by default.
FAQs
What is the Cost?
This Google Sheets Add-on is available for Free for a limited time.
Who can I create posts for with this Add-on?
You can create posts for the Google My Business Locations that are tied to the email address that you are using the tool with. If your email address isn't tied to any GMB Locations, then the tool won't work for you.
Tell me more about how the scheduling works.
Set the hour of day you want the tool to run each day, and each day the add-on will check automatically for posts set with that day's publish date. If the dates match, then the Add-on will publish your post for you.
How does the UTM tagging work?
We've set tagging up for your success and here's how: We set up tagging for you according to the tagging structure shared by Claire Carlile's great UTM tagging guide.
This means that you and your agency or business will have a consistent tagging scheme that makes it easy for you to track the effectiveness of your marketing efforts while using Google Posts.
Okay that's cool, can I customize them the way I want to?
Absolutely! You can set the tags to your own structure. Just go to the CONFIG tab and modify the UTM Tagging
What is the Deletion Policy?
You are free to delete the Add-on if it does not work for you for any reason.
Google My Business Q + A Add-on for Google Sheets
We built this Add-on to help you manage GMB Questions and Answers in an easy familiar way with the aid of Google Sheets.