LBSocial Hub

Tired of wrestling with complex formulas in Google Sheets? Data analysis just got a lot easier.

With the new Gemini AI in Google Sheets, you can stop writing code and start getting insights by simply asking questions in natural language.

We wrote a full, step-by-step tutorial showing you how to leverage this new AI for:

- Quantitative Analysis: Instantly find trends and build charts from sales data using the "Ask Gemini" panel.

- Qualitative Analysis: Use the AI() function to perform sentiment analysis on thousands of rows of text.

- Data Cleaning: Incredibly, watch Gemini extract clean latitude and longitude coordinates from messy user-provided location data.

Google Colab now integrates directly with Gemini, turning AI into a true collaborator in coding and data science.

In this hands-on tutorial, we connect Colab to GitHub and MongoDB, securely manage credentials, and let Gemini generate, explain, and run Python code — building a full Twitter network analysis in minutes, all in the cloud.

See how AI transforms coding from automation to collaboration:

www.lbsocial.net

Discover how to use Google Colab with Gemini to turn AI into your coding partner. This tutorial shows how to connect GitHub and MongoDB, store credentials securely, and build a Twitter network analysis—all in the cloud

In our latest tutorial, we demonstrate how to use the new OpenAI Agent Builder to create a complete AI workflow that can classify questions, explain concepts, run code, search the web, and connect through widgets — all in a simple, no-code interface.

You’ll learn how to apply tools like Guardrails, If/Else logic, File Search, Web Search, Code Interpreter, and Data Transform to design reliable and intelligent AI agents step by step.

Watch the full tutorial on LBSocial:

www.lbsocial.net

Learn to build a complete AI agent with OpenAI Agent Builder. Use Guardrails, File Search, Web Search, Code Interpreter, and logic—all without coding.

Google has just updated NotebookLM for 2025, and the new features make it more than just a note-taking tool—it’s becoming a comprehensive AI learning companion.

In our latest tutorial, we walk through:

- Importing data and creating notebooks

- Using quizzes, flashcards, video overviews, and mind maps

www.lbsocial.net

Learn Google NotebookLM 2025 features—quizzes, flashcards, video overviews, and mind maps. Compare free vs paid plans and watch the full tutorial.

Google Vids is Google’s new AI-powered tool for creating teaching videos directly in the browser.

In this step-by-step walkthrough, we show how to:

✅ Import slides and convert them into video scenes

✅ Add AI avatars and voiceovers

✅ Generate images and short clips with prompts

✅ Edit timelines and apply simple effects

Want to run spatial workflows in QGIS just by typing what you need?With the Spatial Analysis Agent plugin, you can use natural language (not just English) to:

🖌️ Style map layers by location type ⏱️ Summarize time spent at different places 📍 Generate movement paths 🤖 Experiment with AI-powered spatial workflows using GPT-4o

While some GIS and basic coding knowledge are helpful, no advanced scripting is required.

www.lbsocial.net

This tutorial demonstrates how to use the Spatial Analysis Agent plugin in QGIS to perform spatial data analysis using natural language powered by AI.

Creating polished educational videos no longer requires expensive gear or complex editing tools. In this step-by-step guide, I walk through how to use ChatGPT, Sora, and CapCut to build a complete AI-powered video—from research and scripting to visuals, voiceovers, and avatars.

✅ No filming✅ No editing experience needed✅ Ideal for educators, trainers, and content creators

Check out the full post to see how AI tools can turn your ideas into professional videos in minutes.

www.lbsocial.net

Learn how to create high-quality educational videos using AI tools like ChatGPT, Sora, and CapCut—no coding or filming required. This step-by-step guide shows how to automate research, scriptwriting, visual generation, and video assembly using the latest AI features. Ideal for educators, content creators, and anyone looking to produce engaging videos in minutes.