Q: Squarespace blog post automaton
Could RTILA mirror my actions of logging into the CMS back end of Squarespace. Going to the blog post area and create a new draft post. Then go to a Google drive folder to copy the contents of a Google doc to create the new blog content from? Then also make sure all headers and spacing was correct in the document. The last step would be pulling an image file in Google drive to use as the key image in the draft post. Thank you
RTILA
Nov 4, 2024A: Hello Mike
Yes this is possible but we advice a small change in the approach/organization if you want more resilient and scalable automation:
Google drive folder to copy the contents of a Google doc to create the new blog content from?
>>>
The idea is instead of a Google Doc is to have a Google Sheet with content organized in columns, with for instance the following columns:
Blog Title, SEO keywords, Featured image URL/path, marked down content
To have proper display of your text content its better to prepare your text usiung simple html markers such as H1, H2, H3 tags. And have paragraphs within <p>Some paragraphs</p> or div elements such as <div>Some text content</div>
This way the display of text is predictable and the final look of your blog can be tweaked from by your website CSS and template
Let us know if this makes sense
mikep7PLUSHow would RTILA pull or connect to Google Drive/Docs/Sheets? Would this content need to be separated into different cells in the Google Sheet? Also, Could RTILA run a process where it pulls an MP4 video file from Google Drive to upload to an online application for automated AI editing and, once the process is done, downloads the updated file to a different Google Drive folder?
I replied this question on its own thread
mikep7PLUScan you give me an example of what the google sheet would look like with the Html markers? I would like to try this and see what i can do. Or is this one of the automation you would help create for me?
yes as a welcome gesture we can assist you with your first automation. But you need to start building it and then send us the .rtila exported file of your project via ticket and we would then help you unlock/finalize where you would have been stuck