A versatile Node-RED node for interacting with Google Sheets, supporting features like reading, writing, appending, clearing, adding, and removing sheets.
- Installation
- Usage
- Auth
- Sheets
- Cells
- Add/Remove Sheet
- Credits
- Future Plans
- Feature Requests
- Support
- License
Install via nodered pallete or run the following command in the root directory of your Node-RED install
npm install node-red-contrib-google-sheets-advance
Configure the node with your Google service account credentials and the desired method (e.g., get, update, append, clear, add sheet).
For detailed instructions on setting up authentication, sheet IDs, and cell references, refer to the Auth, Sheets, and Cells sections below.
Follow these steps to set up authentication:
- Create a new service account from Google Cloud Console.
- Download the JSON credentials file for the service account.
- Give the service account access to the Google Sheets API.
- Share your sheet with the email address of the service account (e.g.,
sheet-builder@example-413410.iam.gserviceaccount.com
).
To find the sheet ID:
- Open your Google Sheet.
- Copy the ID from the URL (e.g.,
https://docs.google.com/spreadsheets/d/your-sheet-id/edit
).
Referencing cells in Google Sheets:
- The format is
Sheet1!A1:C3
, whereSheet1
is the sheet name,!
indicates the cell range, andA1:C3
specifies the cells. - A range of cells can be a row (e.g.,
A1:A5
), a column (e.g.,A1:E1
), or a block (e.g.,A1:C3
).
To add/remove a sheet from the workbook, simply pass the desired name for the sheet to be added/removed from the workbook in msg.cells
.
This tool is built upon code references and inspiration from the node-red-contrib-google-sheets repository. We acknowledge and appreciate the contributions of the original authors and maintainers of that repository.
Our future plans for this tool include:
- Enhancing user interface for better usability.
- Adding support for additional Google Sheets API functionalities.
If you have any feature requests or suggestions, please open an issue on GitHub. We welcome your feedback and ideas!
For support or questions, you can contact us directly.
This project is licensed under the MIT License - see the LICENSE file for details.