Streaming live at 10am (PST)

Use Googledocs as database for prototyping using Sheetsu API

I just wanted to share really quick a pretty cool way to use google docs as a database.

Using you can create an API from a google sheet that allows you to post to and manipulate data in a google doc thru an API:

In their Beta API there is support for different methods other than just creating new rows.

I tested it in a prototype:

The form data here gets sent to a google sheet and then on another page the data is displayed by pulling the data from the google sheet:

I tested the PATCH feature of the sheetsu api for implementing a like button as an example.

Just thought I’d share as I think this is really useful for prototyping and could help others.


wow this is super cool :slight_smile: I will have a digg into it.
Was it easy to integrate?
Thanks for sharing

1 Like

Here is some sample code to get you started submitting to google docs via a webflow form:

  var Webflow = Webflow || [];
  Webflow.push(function () {
    // DOMready has fired
    // May now use jQuery and Webflow api
    // jQuery snippet for changing HTML form into JSON
    (function ($) {
        $.fn.serializeFormJSON = function () {

            var o = {};
            var a = this.serializeArray();
            $.each(a, function () {
                if (o[]) {
                    if (!o[].push) {
                        o[] = [o[]];
                    o[].push(this.value || '');
                } else {
                    o[] = this.value || '';
            return o;

    //Put the ID of your form here, this will override your form settings in webflow
    $('#wf-form-Sign-Up').submit(function(e) {
    	var isValidForm=$("#wf-form-Sign-Up").valid();
                  alert("Please fill out the required fields");

      // Serialize data to JSON
     // Put the ID of your form here
      var data = $('#wf-form-Sign-Up').serializeFormJSON();

            //Put the url to your sheetsu api here
            url: '',
            data: data,
            dataType: 'JSON',
            type: 'POST',

            // Redirect on Success Response
            success: function(data) {
              // Put where you want the form to redirect to after you submit here
              $(location).attr('href', '')

            // Handle Errors
            error: function(data) {

        return false;

Make sure that your google sheet has the same column headers as the form field names…

In the beta version of the API you can also enable authentication.