Transform and publish your JSON objects into a Google spreadsheet.
Installation
Example usage
;// or use 'import' to get it with types in Typescript // load your Google service account; // get your doc key from the spreadsheet's URL; ; // The array of objects which will build the spreadsheet; // optional; ;
Example result
docKey
- Every Google Sheet has a unique key in the URL
- https://docs.google.com/spreadsheets/d/{docKey}/
Creds
- Go to the Google Developers Console
- Select or Create Project
- Dashboard > Enable APIs and Services > Enable the Drive API for your project
- Credentials > Create Service Account Key
- Select Json Key type and save the downloaded json file to your project
- Once you have created the services account, you will have an email xxx@xxx.iam.gserviceaccount.com. Go to your Google Sheets file and shared the edit permission to the email address.
- For more details, please refer to https://www.npmjs.com/package/google-spreadsheet
Links
- https://developers.google.com/google-apps/spreadsheets/
- https://www.npmjs.com/package/google-spreadsheet
- https://www.npmjs.com/package/array-to-google-sheets
Author
License
This project is licensed under the MIT License and built for OneMeter.com