Create Blank Spreadsheet in Particular Google Drive Folder

Google Sheets by pkpp1233

Add a new spreadsheet with the given name to your Google Drive.

Sometimes this will create a new folder as well if it doesn't match to an existing path.

Connect an Account

Google Sheets

Connect to Google

Setup Your Connector

Choose your Format

More Options

Access Google Sheets - Create Blank Spreadsheet in Particular Google Drive Folder from your tools

or Log in

Step 1: Choose your tool

Step 2: Install Blockspring

Curl Node PHP Python Ruby R jQuery Webhook

curl -H "Content-Type: application/json" -d "{ \"filename\": , \"path\": , \"google_token\":  }" "https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?"

Run this function with a POST request to Blockspring.

var blockspring = require("blockspring");

blockspring.runParsed("create-sheet-in-drive", { "filename": , "path": , google_token:  }, function(res) {
  console.log(res.params);
});

var request = require("request");

request.post({
  url: "https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?",
  form: { "filename": , "path": , google_token: }
},
function(err, response, body) {
  console.log(JSON.parse(body));
});

Visit the node.js quickstart to get started fast.

<?php
$url = 'https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?';
$data = json_encode(array("filename" => , "path" => , "google_token" => ));

// use key 'http' even if you send the request to https://...
$options = array(
    'http' => array(
        'header'  => array("Accept: application/json", "Content-Type: application/json"),
        'method'  => 'POST',
        'content' => $data,
    ),
);

$context  = stream_context_create($options);
$result = file_get_contents($url, false, $context);

var_dump(json_decode($result));
?>

<?php
require('blockspring.php');

var_dump(Blockspring::runParsed("create-sheet-in-drive", array("filename" => , "path" => , "google_token" => ))->params);

Visit the php quickstart to get started fast.

import json
import urllib2

req = urllib2.Request("https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?")
req.add_header('Content-Type', 'application/json')

data = { "filename": , "path": , "google_token": }

results = urllib2.urlopen(req, json.dumps(data)).read()

print json.loads(results)

import blockspring
import json

print blockspring.runParsed("create-sheet-in-drive", { "filename": , "path": , "google_token":  }).params

Visit the python quickstart to get started fast.

require 'rest_client'

response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?', JSON.dump({ "filename" => , "path" => , "google_token" =>  }), :content_type => :json

puts JSON.load(response)

require 'blockspring'

puts Blockspring.runParsed("create-sheet-in-drive", { "filename" => , "path" => , "google_token" =>  } ).params

Visit the ruby quickstart to get started fast.

require 'rest_client'

response = RestClient.post 'https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?', JSON.dump({ "filename" = , "path" = , "google_token" =  }), :content_type => :json

puts JSON.load(response)

library('blockspring')
library('rjson')

print(blockspringRunParsed("create-sheet-in-drive", list( "filename" = , "path" = , "google_token" =  ))$params)

Visit the r quickstart to get started fast.

<script src="https://code.jquery.com/jquery-1.10.1.min.js"></script>
<script src="https://cdn.blockspring.com/blockspring.js"></script>
<script>
  blockspring.runParsed("create-sheet-in-drive", { "filename": , "path": , google_token: }, { "api_key": "" }, function(res){
    console.log(res.params);
  })
</script>

Visit the javascript quickstart to get started fast.

https://run.blockspring.com/api_v2/blocks/create-sheet-in-drive?

Use this URL for webhooks. You'll want to make a POST request.

Finish the setup steps to use Create Blank Spreadsheet in Particular Google Drive Folder in Code.