If you want to log temperature sensor data to Google Sheets using CM4 Maker Board, you are in the right place! Here you will find all the information you need to set up your hardware and software and start data logging with the CM4 Maker Board and Google Sheets.
You can visit Log Thermocouple Sensor Data to Google Sheets using CM4 Maker Board to learn more about it.
To get started, you will need the following hardware and software:
Hardware:
Software:
Raspberry Pi OS with installed Python. If you want to know how to install the Raspberry Pi OS on the CM4 Maker Board, you can visit this tutorial on Boot up Raspberry Pi CM4 on CM4 Maker Board.
To begin, connect the MAX6675 thermocouples to the Grove port on the CM4 Maker Board. In this example, we will use two thermocouples.
Install Required Libraries on Raspberry Pi CM4.
pip install gspread
pip install oauth2client
pip install python-csv
Download the code from Github to your home directory.
git clone https://github.com/CytronTechnologies/CM4-Maker-Board-MAX6675-Google-Sheets
Place the downloaded credentials in the same folder from GitHub. Visit our full tutorial if you want to know how to create Google Credentials. Inside python file max6675_google_sheets_logger.py, edit the name for your json file, email, spreadsheet name and sending interval:
# Your Google Sheets API credentials JSON file
JSON_FILE = 'your_credentials_file.json'
# The email you want to share the Google Sheet with
SHARE_WITH_EMAIL = 'your_email@example.com'
# The name of the Google Sheet
SPREADSHEET_NAME = 'Thermocouple_Data'
# Set sending interval in seconds (s) to read and save data
SENDING_INTERVAL = 60Run your code and you can access the data log from the sheet URL in the Python code or find it in the "Shared with me" section of Google Drive.
Resilient Data Logger
For a more advanced approach, use the max6675_google_sheets_resilient_logger.py script to avoid data loss during connection errors or high-traffic server events. It saves data in a CSV file before uploading it to Google Sheets and resumes the upload once the connection is restored. This script also uses different threads to save data to a CSV file and upload it to Google Sheets, ensuring a more consistent time interval when reading the thermocouple sensor.
For more information on the CM4 Maker Board, check out the datasheet here:
You can visit Log Thermocouple Sensor Data to Google Sheets using CM4 Maker Board to learn more about it.
If you need further assistance, we welcome you to our technical forum or you can contact us through email support@cytron.io where our team will be happy to assist you.
Let's start building with CM4 Maker Board!