The first step is to copy our template Google Sheet™ which is pre-formatted for the add-on. You can access the template sheet here.
To copy the template:
Open the link.
Click on the "File" menu at the top left corner of the Google Sheets™ interface.
Select the "Make a copy" option from the drop-down menu.
Save it to your desired location in your Google Drive™.
After you've copied the template, you need to install our Social Media Officer Add-on.
Go to the Extensions Menu.
Click on 'Add-ons' menu and click on 'Get add-ons'
Search for 'Social Media Officer', click on it and then click "Install".
Google™ will ask for permissions to run the add-on. These permissions are necessary for the add-on to function, such as the ability to write to your Google Sheets and to make network requests on your behalf to post on social media.
Once you've installed the add-on, you will see it in the extensions menu as 'Social Media Officer'.
Now, you will need to enable your subscription.
When you're ready, click on "Extension" > "Social Media Officer" > "Subscribe"
You will be redirected to the payment gateway. Follow the steps there to enable your subscription.
Now, you're all set to connect your Social Media accounts with this tool.
When you're ready, click on "Extension" > "Social Media Officer" > "Show Sidebar"
In the sidebar click on "Authorize Facebook™" or "Authorize Instagram™" or similary for all the Social Media platforms you want to post to. This will take you to the authorisation and page selection tab.
On authorization, close the new tab and go to the google sheets tab where you will be presented with the page selection in the sidebar.
Now, you're all set to start scheduling your posts.
In your copied template, fill out the necessary details for each post such as the platform, message, date, time, and any media or link attachments.
The add-on will start to schedule your posts based on the details you provided.
Images should be added as public URLs and should be less than 5MB.
You can view the status of each post in the "Status" column of the sheet. If there are any issues with scheduling a post, an error message will appear in the "Error Message" column.
Click on "Extension" > "Social Media Officer" > "Generate Campaign"
In the sidebar, select the number of days you want to generate the marketing campaign for.
Write a short description of the product/service/event you want to prepare the campaign for in 'Product or Service Details'
Write a short description of what the campaign wants to highlight in 'Campaign Details'
Congratulations! You're now ready to automate your social media posts using our Social Media Officer Add-on.
For any queries or issues, please visit our Support page. Happy scheduling!