ESP32 Modbus To Google Sheets

@teknoteam

Hi, i already did a g-sheet uploader using esp32, and I have rs485 modules. I can send you a picture in chat. However I need the Selec controller to be sure that everything works, are you willing to advance up-front the costs for such device ? It costs nearly 12000 INR. Cheers, Alex.

@thienan2050

Hi, Your project is very similar to a solution I recently implemented for another client, where I developed an ESP32-based logger that pushes data to Google Sheets. In that project, I used UART instead of Modbus RTU. Therefore, I will need about one extra day to properly implement the Modbus register polling. Please feel free to connect with me for more details ------------------------------------------ Best regards, Bui Thien An

@alectro86

I will design a robust ESP32 firmware that ensures seamless Modbus data collection and fail-safe synchronization with Google Sheets, implementing specific recovery logic to prevent data loss during network drops. I understand the nuances of the Modbus protocol and how to handle electrical noise or communication timing issues that often cause standard prototypes to fail. My Technical Plan for your project: • Reliable Polling: Optimized Modbus stack to ensure precise register reading without lag. • Cloud Integration: Using Google Apps Script API for direct and secure data logging. • Stability: Watchdog timers and reconnection algorithms to ensure the system runs 24/7 without manual resets. To tailor this solution to your needs, I have a few technical questions: 1. Are you using Modbus RTU (RS485) or Modbus TCP? 2. Would you like a local backup (such as an SD card log) in case the Wi-Fi connection is temporarily lost? I am committed to delivering a professional-grade solution that exceeds your expectations. Let’s discuss the details. Best regards, Alejandro Elsesser

@tnowsolutions

Hi, I can provide a firmware-ready solution for your ESP32 with MAX485 to poll the Selec UCI 500 PID controller over RS-485/Modbus RTU and push temperature readings to a Google Sheet every 60 seconds. My approach: Implement a lightweight, reliable polling loop that reads the temperature once per minute. Use a simple captive-portal web interface on the ESP32 for entering Wi-Fi credentials. Send readings as a single CSV line to your Google Sheet via an Apps Script HTTP endpoint. Keep code clean, well-commented, and memory-efficient for future OTA updates. Deliverables: Fully compilable firmware (Arduino IDE or PlatformIO) with build instructions. Wiring diagram for ESP32 ↔ MAX485 ↔ RS-485 A/B and power. Step-by-step setup guide from flashing to live data in Sheets. Short demo (video/screenshots) showing successful 60-second polling and logging. The solution will ensure reliable, continuous logging with minimal intervention—just wire, flash, configure Wi-Fi, and start seeing consecutive rows in your Google Sheet.

@mscmateussantos

Hello! this is my specialty! I am an electronics engineer and embedded systems specialist, with an emphasis on the ESP32, for which I have developed hundreds of applications, for both industrial as well as home scenarios. I prefer to work with PlatformIO and I also have in the past hooked up the ESP with google sheets, which is pretty simple. Hope that I can help you!

@ElecHamza

Hi, I will develop a robust ESP32 firmware that integrates Modbus RTU polling with a seamless Wi-Fi Manager for easy network configuration. I will implement the MAX485 communication logic to precisely target the Selec UCI 500 registers and transmit data to your Google Sheet via an efficient Apps Script endpoint. You will receive clean, documented code and a clear wiring schematic to ensure a straightforward hardware setup. My focus is on creating a lightweight, reliable system that supports future updates while maintaining consistent data logging. I look forward to helping you automate your temperature monitoring. Best regards

@Jafferi12

Managing the RS-485 timing on an ESP32 can be tricky when the Wi-Fi stack is active, but I can set up a non-blocking Modbus RTU poll to ensure the Selec UCI 500 stays connected without crashing the web portal. Since you need OTA headroom, I will keep the firmware lightweight by using a simple captive portal for Wi-Fi provisioning instead of heavy libraries. I will provide clean, commented code for the Arduino IDE that handles the 60-second polling cycle and pushes data to your Google Apps Script via a secure HTTPS POST. To make sure you don't need anyone else for this, I’ll also include a clear wiring schematic and the Apps Script snippet so the CSV rows land perfectly in your sheet from the start. You’ll get a full package: the firmware, a wiring guide for the MAX485 connections, and a quick-start doc to get the data flowing. Let's get this board online. Send me a message and we can get started.

@Hemantt841

With over 15 years of experience in software development and digital solutions, I’ve collaborated with startups, mid-sized companies, and enterprise-level clients, successfully delivering more than 200 projects across various industries. My expertise includes electronics and microcontroller programming, which makes me well-equipped to tackle your firmware solution for the ESP32. This project aligns perfectly with my background in embedded systems and HTTP integration. I’ll implement a clean and efficient firmware solution using either Arduino IDE or PlatformIO, ensuring that the polling mechanism retrieves temperature data every 60 seconds while maintaining a straightforward user experience for Wi-Fi setup. Comprehensive documentation will accompany the firmware, outlining everything from wiring diagrams to setup instructions, so you'll be able to see your Google Sheet update seamlessly. I propose a structured approach to ensure reliability and ease of use. The code will be optimized for memory, allowing for over-the-air updates in the future. Together, we’ll create a straightforward setup that allows you to input SSID and password through an intuitive web interface. If you have any specific requirements or ideas, let's discuss them further.

@Biswanath108

Hi, Your project is very clear and well-defined, thankyou for providing such precise information, I can build exactly what you're describing in a clean, firmware-ready format. Here’s how I would implement your solution: Overview - ESP32 communicates with Selec UCI 500 over RS-485 using MAX485 - Modbus RTU polling every 60 seconds (non-blocking, reliable retry handling) - On first boot (or reset trigger), ESP32 opens a captive-portal Wi-Fi setup page - Wi-Fi credentials stored securely in NVS - Temperature reading sent as a single CSV line via HTTP POST to your Apps Script endpoint - Memory footprint kept modest to preserve OTA capability What i will deliver - Fully compilable firmware Arduino IDE - Clean, well-commented, production-ready code - Wiring diagram (ESP32 ↔ MAX485 ↔ RS-485 A/B + power) - Step-by-step setup guide (flash → Wi-Fi config → live sheet logging) - Demo video showing: - Successful Modbus polling - 60-second interval logging - Data landing automatically in Google Sheets To ensure reliablity - Robust Modbus timeout & retry handling - Watchdog-safe non-blocking timing (millis-based, no delay loops) - Graceful Wi-Fi reconnect logic - HTTP status verification before confirming delivery - Lightweight memory usage for future OTA updates If you want i can also add basic fault logging and configurable polling intervals. Looking forward to working on this, Best regards, Biswanath Mukherjee

@sandipm1307

Having worked extensively with industrial automation and PLCs, I'm well-versed in the nuances of RS-485/Modbus RTU and MQTT. My experience translates brilliantly into this project, ensuring that your ESP32, aided by the MAX485 transceiver, effectively polls your Selec UCI 500 PID controller for temperature every 60 seconds, sending the data to Google Sheets via an Apps Script HTTP endpoint. I value simplicity in design and have a knack for crafting clean, well-commented code, which aligns perfectly with your project's needs. The resulting firmware will be compilable, complete with clear build instructions. A detailed wiring diagram depicting the ESP32 ↔ MAX485 ↔ RS-485 A/B and power connections will be provided alongside quick setup notes to get you up and running effortlessly. My commitment to relatability extends beyond just coding. I'm aware of the importance of on-site troubleshooting and client satisfaction, thus assuring you a practical solution that is both cost-effective and high-performing. Post the completion of your project, I'll create a short demo video substantiating a successful polling cycle in sync with your Google Sheet. Choose me for an efficient and reliable implementation that will automate temperature-tracking completely; upgrading not only your system's performance but most importantly-your peace of mind!

@kathirvel95a

I’ve already built a similar ESP32 + MAX485 Modbus RTU solution that polls industrial devices and pushes CSV data to Google Sheets via Apps Script. I can deliver clean, memory-efficient firmware with captive portal Wi-Fi setup and reliable 60-second polling in a short time. Ready to start immediately.

@mandalsurajkumar

Hello there, I read your project for firmware developement for ESP32 to collect data usng Modbus and WiFi. I am a firmware developer having worked with ESP32 S3 microcontroller. I have developed driver for using its peripherals by controlling their register. I also have experience collecting data using WiFi. I can help you complete this project using any version of ESP32. I can help you complete this project with accuracy, kindly initiate the chat and discuss further on this. Thank You

@Habib821

dear client i have read your requriments i fully assure i can do i have experiace in control system and embedded system which ensable me to work perfectlyas an Embedded Systems Developer, I specialize in interfacing microcontrollers with different protocols, one of which includes Modbus RTU and RS-485 that you require for your project. I have worked on similar projects where I have effectively communicated with RS-485 devices using the ESP32 and MAX485 transceiver. Additionally, my thorough understanding of working with sensors such as the Selec UCI 500 PID controller allows me to retrieve data efficiently. Moreover, I have vast experience in setting up local Wi-Fi networks and using HTTP endpoints to post data to Google Sheets. By leveraging Arduino IDE or PlatformIO for clean coding and resource optimization, I can ensure that the data is consistently and neatly pushed to your Google Sheet as a single CSV line in the next free row without manual intervention.

@engrrusama

I've done a project to write data to google sheet directly with esp32. Hi Sir, I have 4 years of experience working with ESP32 and Arduino. I've done a project to write data to google sheet directly with ESP32. Also, I'm working with RS485 communication in my current project to read the DALY BMS data and send it to the Cloud. I'm comfortable working with esp32. As you also want to set the WiFi manager, we can use the WiFi-Manager library that lets you set the google sheet adress and wifi credentials easily. In my work, I'll provide you with a working video, wiring diagram, and code file. Let me know if you have any further questions we can get on a call. Regards, Engr Usama

@nikaa003

Hi! I see you need a firmware for ESP32 to poll data via Modbus RTU and push it to Google Sheets. I have extensive hands-on experience with Arduino and ESP32 from my years of study as a Telecommunications Engineer. While I have completed many technical projects during my university years, I am just now starting to upload them to this platform's portfolio—one of which is already there for you to see (environmental monitoring system). I am new to Freelancer.com and I am looking for an opportunity to prove my skills here. I am highly motivated to make this my first successful job. I perfectly understand the requirements for Modbus communication (RS-485), Captive Portals, and Google Apps Script. If you give me this chance, I guarantee you will receive professional, clean, and perfectly working results. I am ready to start immediately and earn my first positive review through hard work and quality!

@engrhasan01

Hi, I’m an Embedded Systems Engineer with solid experience in ESP32 firmware, Modbus RTU over RS-485, and cloud integrations, and I can deliver a compact, firmware-ready solution for your Selec UCI 500 polling system. I will implement reliable Modbus RTU communication (via MAX485) to read temperature every 60 seconds, integrate a lightweight captive-portal style Wi-Fi configuration page for SSID/password entry, and post each reading as a single CSV line to your Google Apps Script endpoint. The code will be clean, well-commented (Arduino IDE or PlatformIO), memory-efficient to preserve OTA capability, and include wiring diagrams, step-by-step setup notes, and proof (video/screenshots) of successful periodic data logging to Google Sheets.

@Madusha0000

Hi there, ​I have read your requirements for the ESP32 data logging solution. As a firmware developer experienced in Industrial IoT and Modbus RTU, I can deliver a robust solution for your Selec UCI 500 setup. # ​Implementation Plan: ​Modbus Polling: Use ModbusMaster library to poll the Selec UCI 500 every 60s via RS-485/MAX485. ​Captive Portal: Implement WiFiManager for easy Wi-Fi credential setup without hardcoding. ​Google Sheets: Set up a Google Apps Script HTTP endpoint to push data as CSV rows. ​Reliability: Clean, well-commented code with low memory usage for future OTA updates. # ​Deliverables: ​Full Arduino source code. ​Wiring Diagram (ESP32-MAX485-Controller). ​Step-by-step setup guide. ​Google Apps Script code. ​Demo video of successful data logging. # ​Proposed Milestones (Total: ₹5,750 INR): ​Milestone 1 (50%): Hardware setup, wiring diagram, and successful Modbus polling. ​Milestone 2 (50%): Google Sheets integration, Captive Portal, and final handover. ​I am ready to start immediately. ​Best regards, Madusha Batagodage

@santhosh1718

I will develop a solution using ESP32 to poll data from your Selec UCI 500 PID controller via RS-485, allow easy Wi-Fi configuration through a captive portal, and automatically log temperature readings to Google Sheets every 60 seconds

@Rezeki19

Hi, I am an ESP32 firmware developer with hands-on experience in IoT systems, Modbus RTU communication, and web-based device configuration. I have built multiple ESP32 projects involving sensor integration, WiFi provisioning via captive portal, and real-time data pushing to cloud platforms. For this project I will deliver complete firmware that polls the Selec UCI 500 PID controller via MAX485 RS-485 Modbus RTU every 60 seconds, provides a simple captive portal web page for WiFi credential input, and pushes each temperature reading as a CSV row to your Google Sheet via Apps Script HTTP endpoint. Code will be clean, well-commented, and memory-efficient for future OTA updates. I will also provide a complete wiring diagram and step-by-step setup guide. Ready to start immediately. Feel free to ask any technical questions.