Python/MicroPython 传感器记录仪：无缝写入 Google Sheets

项目简介

健壮的传感器数据直传 Google Sheets 方案。通过简易 HTTP 请求连接微控制器与轻量服务端，利用 gspread 库落盘。开始前请按 gspread 文档完成 OAuth2 授权，授予脚本访问目标电子表格权限。

硬件连接 (Wemos D1 mini / ESP8266)

• D0 → RST：深度睡眠唤醒必需
• + → 3.3V
• – → GND
• Signal → A0

遇到问题欢迎评论区留言协助排查。

原理图

MicroPython 核心代码

import machine
import urequests
import time

# RTC 处理深度睡眠唤醒
rtc = machine.RTC()
rtc.irq(trigger=rtc.ALARM0, wake=machine.DEEPSLEEP)

# ADC 读取传感器电压
adc = machine.ADC(0)

######################
# 传感器校准参数
######################
# 参考值 (倒数 ×1000)
# 干燥空气 = 759 (0%) → 1.31752305665349143610013175231
# 水 = 382 (100%) → 2.61780104712041884816753926702
# 差值 = 1.30027799046692741206740751471
# 1% 相对湿度 = 0.0130027799046692741206740751471

hours = str(time.localtime()[3])
mins = str(time.localtime()[4])
secs = str(time.localtime()[5])
if int(secs) < 10: secs = '0' + secs
if int(mins) < 10: mins = '0' + mins
timestr = f"{hours}:{mins}:{secs}"

# ADC 读数转相对湿度 (%)
variable = (((1 / adc.read()) * 1000) / 0.0130027799046692741206740751471) - 101
variable = max(0, min(100, variable))

# 发送至本地端点
url = 'https://192.168.1.2:8000/solomon'
headers = {'content-type': 'application/json'}
data = f'{{"Value":"{variable}","Time":"{timestr}"}}'
resp = urequests.post(url, data=data, headers=headers)
print(resp.json())

# 25 秒后下次采集并进入深度睡眠
rtc.alarm(rtc.ALARM0, 25000)
machine.deepsleep()

来源：Python/MicroPython Sensor Logger for Google Sheets