Push to GSheet

Send any [["data"]] to a Google spreadsheet, in a matter of seconds.

1 First, connect to your Google account:

2 Create a Google spreadsheet:

3 Copy/paste this snippet (that's all it takes):

// 1. npm install @bearer/node
// 2. Initializing the API client
const Bearer = require('@bearer/node')('FUFbE-aEBIbyWN5aVuX3wpWVp5pMOL8C')
const gsheet = Bearer.integration('google_sheets')

// 3. Define spreadsheet and values to append
const spreadsheetId = '{{getSpreadsheetId()}}'
const data = [["firstname", "lastname"], ["John", "Doe"]]

// 4. Send data with a POST request
gsheet.auth('{{getAuthId()}}')
.post(`${spreadsheetId}/values/A1:append`, {
body: { values: data },
query: { valueInputOption: 'RAW' }
}).then(() => { console.log('Saved!') })
# 1. gem install bearer
# 2. Initializing the API client
require "bearer"
bearer = Bearer.new("FUFbE-aEBIbyWN5aVuX3wpWVp5pMOL8C")
gsheet = bearer.integration("google_sheets")

# 3. Define spreadsheet and values to append
spreadsheetId = '{{getSpreadsheetId()}}'
data = [["firstname", "lastname"], ["John", "Doe"]]

# 4. Send data with a POST request
gsheet.auth('{{getAuthId()}}').post(
"#{spreadsheetId}/values/A1:append", {
  body: { values: data },
  query: { valueInputOption: 'RAW' }
})
# 1. pip install bearer
# 2. Initializing the API client
from bearer import Bearer
gsheet = Bearer('FUFbE-aEBIbyWN5aVuX3wpWVp5pMOL8C') \
.integration('google_sheets')

# 3. Define spreadsheet and values to append
spreadsheetId = '{{getSpreadsheetId()}}'
data = [["firstname", "lastname"], ["John", "Doe"]]

# 4. Send data with a POST request
gsheet.auth('{{getAuthId()}}') \
.post(spreadsheetId + '/values/A1:append', \
body={ 'values': data }, \
query={ 'valueInputOption': 'RAW' } \
)
<?php
// 1. composer require bearer/bearer-php
// 2. Initializing the API client
require __DIR__ . '/vendor/autoload.php';
$bearer = new \Bearer\Client("FUFbE-aEBIbyWN5aVuX3wpWVp5pMOL8C");
$gsheet = $bearer->integration("google_sheets");

// 3. Define spreadsheet and values to append
$spreadsheetId = "{{getSpreadsheetId()}}";
$data = [["firstname", "lastname"], ["John", "Doe"]];

// 4. Send data with a POST request
$gsheet->auth("{{getAuthId()}}")
->post($spreadsheetId . '/values/A1:append', [
"body" => [ "values" => $data ],
"query" => [ "valueInputOption" => "RAW" ]
]);
Copy
See the results in your Google Sheet

Why?

The Google Sheets API is awesome. But for something as simple as pushing data to a spreasheet, it takes half an hour just to setup: (i) creating a Google app, (ii) grabbing credentials, (iii) retrieving an access_token, (iv) testing, etc.

There's definitely an easier way to do it!

Who is it for?

If you're reading this, chances are that you have tons of data, but no time to lose on setup.

Whether you're a developer, a growth hacker or just looking to quickly integrate with Google Sheets, I built this tool just for you.

How it works?

It uses Bearer API client to call the /append endpoint from the Google Sheets API, along with these parameters:

  • sheetId: The sheet ID that you provided.
  • authId: An authentication token (learn more)
  • data: an array in two-dimensional format

The snippets above show how to append data. But they are easily customizable. For example, change the .post() to a .get(). Update the endpoint. You have access to the whole Google Sheets API.

Is it free?

Yes! You are free to use it in any project. You can even grab the code which is open source.

Privacy policy

Your data remains your data. Nothing that passes through this service will be reused, resold or used for any commercial purpose. For a full note, read our Privacy Policy.

If you no longer want to use this app you can remove it here.