Converting ChatGPT social schedule into a Sharing Schedule

Once you have your social schedule from Chat GPT in an excel spreadsheet you will need to do two things -

Convert this to a sharing schedule
Schedule in all the posts you can or at least the coming week

First check the schedule is as you want for at least 3-4 weeks. Then -

Open your main Sharing Schedule you will be using so it is ready
Go back to the ChatGPT schedule
First add a new column "Link" this is so there will be a column added for you to put the social link in and make sure there are no empty rows
Highlight and copy all the columns and rows you want in the sharing schedule including the column titles and the blank Link column
Go back to your open Sharing Schedule and to the Active sheet for the month you will be uploading
Go to the first A1 cell, right click and Paste Special | Transpose
This should put all the content into the sharing schedule but in columns instead of rows
Make sure the Date column shows the date otherwise change it under the "Number" menu (and make sure all other columns look OK)
Then add a row below "Link" saying "Add link to client task" to remind you to do this when you put the link in the schedule - this will just make it much easier when you are reporting to a client to quickly click the link to share
Then go to your "Sharing Groups Template" (the end sheet of the document) and copy the list of groups
Back to your month sheet and paste these below the "Link" in the first column
You will now be able to easily schedule your posts in Facebook Business Suite

Note you can't bulk upload posts. So now go to your Facebook page and click on Meta Business Suite in the left column.

Referring to your schedule you can schedule posts for Facebook and Instagram up to 30 days in advance.

You can then select certain posts to schedule in on LinkedIn and Google Business Profile. To do this -

First copy by highlighting all the cells from rows Date to Link (1-6) and all scheduled posting details
Go to the month sheet for "LI and GB" and paste
Then in column A add a row name "LinkedIn" and one for "Google Business"
Then remove all columns you won't be posting (probably just keep all the posts referring to a business)
Then you can schedule into LinkedIn and Google Business - perhaps schedule in each alternate one

Use this as your active sharing schedule and enter the date and which profile shared the post and to in the box next to the group or channel.

Approx each week archive those posts you won't be sharing any more by copying and pasting them from the "Active" and "LI and GB" into the Archive sheet. This will move the next weeks posts along to make it easy so you don't need to scroll.

End of Month Sheet Shuffle

At the start of the next month, if you want to still share some of the posts from the previous month copy and paste them into the start of your next month sheet (will only be for FB).

Then move the 3 sheets for the month just gone to the end of the sheets list. You can always go to these sheets to get links if you need for reporting.

How to Schedule

Go to Facebook Meta Business | Create post

First do Facebook unless you are doing a video/reel as you have to add an image with Instagram but you don't want to if you want the social link in Facebook

Create your post, copy your content (all of it including the link and emoji's) and schedule

Then create another post for Instagram, paste the content and schedule

Do all these first then separately go and schedule your LinkedIn and Google Business posts

Update Client Boards

As you schedule in a post go and also set up a task in the particular client's board for the post date

Once the post is published also their task will become due

As you add the post link into the sharing schedule also copy it into the client task and move the task to the Linku2 Pending stage of the Things to Do Board.