Skip to main content

4 Steps to Automate your Facebook posts using AI


I have created a Facebook Page named Cope With Tech that serves as my daily newsletter. It looks for content using a search engine that I self-hosted. I set the search terms or keywords. Then, it opens the website from the search result and uses a self-hosted Large Language Model (LLM) to create a summary. This is then stored on a spreadsheet and scheduled to be posted on Facebook. Here are the 4 steps to automate your Facebook Posts:
  1. Workflow automation - Use n8n. I have installed n8n on my own server. You can also install in your laptop or desktop computer.
  2. Content retrieval - Searxng
  3. Facebook post composition - Ollama + Gemma3
  4. Scheduling - n8n + Google Sheets

Comments

Popular posts from this blog

Adding a Footer to the DataGridView component

I have been searching for sites and forums that would give me a any hint on having a footer on the .net DataGridView control. It was frustrating. I found some, but not what I was looking for. I use windows forms. It would have been easier if I was into web. I decided to create one for myself. It's not complete, but it works with me. It needs improvement and I hope that some programmers who might pass through this blog will help me with it :D. Limitations: Cannot set Footer values during design time. Can sometimes hide a row when scrolled to the last item in the grid. What I did was just create a user control that inherits the DataGridView control and add a StatusStrip to act as the footer. public partial class MyDataGridView : DataGridView { public StatusStrip Footer { get { return (StatusStrip)this.Controls["Footer"]; } } private bool _footerVisible; [Browsable(false)] /// /// Sets or Gets the va...

Using Crystal Reports 10 with C#.net and Firebird

C# express doesn't include a report designer or viewer. Reports however, is very much needed when creating a business software. Since C# express doesn't include a report designer, we need to find other means. One is to use a free report such as MyNeoReport. This however may not work under many circumstances. The other alternative would be to use a proven report engine and designer-Crystal Report. Crystal Report has been used by many developers (in our city). However, using a free programming language and IDE, and a free database is very limiting. Not much information can be gathered on the net either (with regards to reporting as of this writing). Here's a way to use Crystal Reports using Firebird database and C# Express as software development IDE: Pre-requisites: C# Express 2005 EMS SQL Manager 2005 for InterBase & Firebird Lite Crystal Reports 10 Create the following database: Name: TestDB1 Tables: TESTTABLE1 Columns:  ID - PK, INTEGER,AUTOINCREMENT DES...

Open a Lenovo 3000 G410 Battery

One of the common problems with laptops is the deteriorating performance of its battery. Laptop batteries are made up of Lithium Ion (Li-ion). I have a laptop that is more than a year old. Last week, its battery went totally dead. I'm still looking for a replacement. I'm very careful in finding one because most cheap alternatives are poor in performance (with only 45 mins up time compared to the original 3-4 hours). Some are overly priced. I now have a prospect seller and will be purchasing after this post. Well, to continue, out of my curiosity, I opened the battery. The laptop is a Lenovo 3000 G410. Before my exploration, I took the specifications of the battery. It turned out that it's manufactured by SANYO. Here are the specifications: Battery name: PABAS024 Unique ID: 3658QSANYO PABAS024 Chemistry: LION I really don't have any knowledge about the hardware. All I know is that it can be charged and discharged. Despite my limited knowledge, I still opened it up ...