object-to-google-spreadsheet

Quickly publish a set of unstructured JSON objects into a Google spreadsheet that you specify.

Installation

Example usage

const O2GS = require('object-to-google-spreadsheet');

// require your Google json credentials file
const creds = require('./creds');

const myReport = new O2GS(creds, '<Your docKey here>');

const options = {
    sheetName: 'My Awesome Report', // sheet name
    rowName: 'person', // the key name of the base of your rows
    properties: 'properties', // the name of the array of objects containing your base's properties
    a1Field: 'details', // the value of the A1 field
    sort: true // sort fields
}

const docs = [
    {
        person : "John",
        properties : {
            Age: 25,
            Address : "16 main st."
        }

    },
    {
        person : "Jane",
        properties : {
            Age : 24,
            Hobbies : "swimming"
        }

    }
]

// push your object to the sheet
myReport.push(docs, options)
.then(result => console.log(result))
.catch(err => console.log(err))

Example result

docKey

• Every Google Sheets has a unique key in the URL
• https://docs.google.com/spreadsheets/d/{docKey}/

Creds

1. Go to the Google Developers Console
2. Select or Create Project
3. Dashboard > Enable APIs and Services > Enable the Drive API for your project
4. Credentials > Create Service Account Key
5. Select Json Key type and save the downloaded json file to your project
6. Once you have created the services account, you will have an email [e-mail]. Go to your Google Sheets file and shared the edit permission to the email address.
7. 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

Ehab Khaireldin

License

This project is licensed under the MIT License and built for OneMeter.com