Tunnel smartphone to Google drive through a n8n local (Macbook pro - Ubuntu)

Hello,

I’m really newbi into n8n working locally into my Macbook pro on Ubuntu :

  • Apple Inc. MacBookPro11,1 (middle 2013)
  • Ubuntu 24.04.2 LTS
  • Using n8n throught Docker with Ollama in a bridged network

I had to install ubuntu, n8n was not available on Big Sur because my macbook it’s to old…


1. Actually I use my phone to do some “research” around the ecological transition, when i see something interesting.

Examples :

- https://reporterre.net/Le-carburant-des-avions-est-mieux-rembourse-que-nos-medicaments
- https://www.facebook.com/share/p/1ADgdvM9tP/
India use bamboo as water bottle to reduce plastic use

Sometimes I add the type of the content :

- https://www.facebook.com/share/p/1PeXTWeAGz/
Homme flexitarien vs burger man (image)

2. I share it into a Canal into a Whatsapp group.

Community Group -> Link canal

3. After i go to my laptop to copy paste a lots of this type of “data” into ChatGPT for create a special copy paste to add it into a google sheet…

Smartphone -> Whatsapp app -> Whatsapp Web -> Chatgpt -> Google sheet


So I wanted create a simple process about recover these contents (URL and sometime and title if it’s not into the link)

I would like to create an automatisation trough n8n, locally in my laptop by connecting through ollama and paste it into a google sheet, a new one to start without mess the old one…

My laptop will not work 24/7 but we can create a click event or daily event to recover all the lastest messages when it’s working.

I find a way kinda tricky because apparently with Whatsapp Business, we cannot check a specific canal… Maybe Through Venom Bot but i’m afraid to be ban because it’s not accepted by Whatsapp’s rules… But it will be really nice because after i would like to add my partners to add content too and this content will be tagged into the data sheet by his/her name.

So i find this solution through a Telegram bot :

So i create my bot, find the token, connect it and find normally the chat ID with the bot and I…

But when i try to set it up, n8n tell me this issue :

Problem running workflow

Bad request - please check your parameters

Show Details

Telegram Trigger: Bad Request: bad webhook: An HTTPS URL must be provided for webhook

I need free and open source solution, working locally and please stable, that I doesn’t have to regenerate an address through Ngrok…

What do you think guys ?
What do you recommend to do ?

I hope to be enough clear
Good luck and thanks in advance …

Earthly
Lammeur