For this automated process, we developed four essential flows that go from processing eye-catching images to producing creative content to scheduling and publishing on social media. Witness how this change enabled our client to concentrate on their core activities while maintain a strong online presence.
The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
Our client is a renowned vacation rental agency with a strong online presence through their unique website. By showcasing rental properties on their website, their primary business model focuses on bringing together property owners and potential renters. However, the agency realized they needed to streamline and automate their social media marketing strategy, especially on sites like Instagram and Facebook, as their portfolio of rental properties grew.
Therefore, this project's main goal was to reduce the amount of manual work needed to manage social media while still having a reliable and interesting online presence. To accomplish this, our customer wanted to automate the procedure for planning and publishing content on Facebook and Instagram. The desired outcome was to create a hands-free, more effective social media marketing system that would free up their team to concentrate on other crucial facets of their business.
We used a strategic approach and modern technology to achieve the client's goal. Platforms like 0CodeKit, Airtable, OpenAI, and Make were key components in automating content creation, scheduling, and publishing. This case study provides in-depth information about the methods employed, challenges encountered, and the remarkable results achieved through the simple integration of automation technology into our client's social media marketing workflow.
Travelers are increasingly using internet and social media to select their ideal getaways, making the vacation rental industry and interesting and competitive field. Our customer faced a set of industry and specific challenges and led them to look for creative solutions.
Automating social media content creation and posting for our client required a multi-step process that smoothly combined human interaction with AI-powered tools. This process can be divided into four key flows:
To start the process, property owners send an email containing images of their properties to a dedicated mailbox. These images capture the charm and beauty of the rental properties and act as valuable visuals assets for the social media content.
Next, we use a webhook that collects all incoming emails including guest-submitted images to ensure a quick and automated response. This essential step streamlines the reception of images. These images are then systematically kept in SharePoint after being received and are all contained within the same organized folder structure, making it simple to retrieve and access them afterwards.
An image is automatically sent to the powerful image processing tool 0CodeKit when is added to SharePoint. 0CodeKit must first analyze these images to create descriptive tags that accurately describe the content captured in each image.
Simultaneously, we keep an extensive database in Airtable "Table 1", acting as a central hub for storing important image information. The filename of the image, working as a direct link to the corresponding image in SharePoint, the tags generated by 0CodeKit (such as "summer" or "beach"), and the sender's email address are all stored in this table.
This flow makes sure that every month, a new batch of 25 content ideas is generated and carefully recorded, continually enhancing our client's pool of social media post ideas to maintain a consistent and engaging online presence.
At the beginning of the month, we gave ChatGPT a specific prompt, referred to as Prompt 1. Its objective is to request creative suggestions for social media posting that are specifically tailored to the demands of our client. Two target audiences have been identified: "Guest" and "House Owner" and a post idea as the output is sook.
ChatGPT processes Prompt 1 and produces a list of ideas. These ideas have been thoughtfully chosen to attract the target audiences; guests are received with a formal greeting while property owners are given a more relaxed greeting. Additionally, to increase post visibility, ChatGPT also suggests relevant hashtags, such as #gbsylt.
The generated ideas are systematically recorded in Airtable "Table 2", which also contains fields such as post description, the target audience, image suggestions, an "approve" checkmark, the planned posting date, a "generate" button, and a linked entry to "Table 1".
By simply clicking the "Generate" button starts the flow process and sets the stage for the creation of engaging social media content. Subsequently, we send Prompt 2 to ChatGPT with the main objective of generating a detailed post description and associated tags based on the idea previously generated. The target audience and the idea are considered inputs, and the post description text and relevant tags are the desired outputs.
The saved generated post description texts and tags can be found in "Table 2", making this important content available for usage. Here, we retrieve a list of unused image tags from "Table 1" to illustrate the text with images. These tags are crucial for locating images that fit perfectly the post description. To accomplish this, we send Prompt 3 to ChatGPT along with a set of tags for each image and the post description.
The results of the matching process are kept as separate rows in "Table 3". Links to the post descriptions in "Table 2", image links from "Table 1", an "approved" checkmark, and the planned posting date are all included in this table. This flow makes sure that each generated content idea has a perfect visual match, therefore, the system examines the images to determine the top five matches for each idea.
Now our client is given the chance to review and approve the posts, once these have been generated. Once satisfied, they may then precisely regulate their social media strategy by scheduling posts for particular days and times.
Now, the system takes charge and posts on the scheduled day and time. It chooses a post that has been authorized, does any necessary filtering, and simultaneously shares it on Facebook and Instagram. Then, proceeds to change the status in Airtable as soon as the posts have been successfully shared, enabling effective tracking and management.
Faced with the difficulties of a competitive market and the necessity for efficiency, our client sought to streamline their social media marketing activities. We embraced innovative technology to build a hands-free and social media marketing system, utilizing tools like 0CodeKit, Airtable, OpenAI and Make. For this automated process, we developed four essential flows that go from processing eye-catching images to producing creative content to scheduling and publishing on social media. Witness how this change enabled our client to concentrate on their core activities while maintain a strong online presence.
Ready to start your own automation journey? To find out how our experience can take your business to new heights, contact us today!
