Example: Google Sheets NPM

Show and tell
,
97

@gal-morad Thank you! Table Master looks cool, but I need to feed my data into a dynamic table, so I’m not sure that will work. 2 follow ups…

  1. I have a database titled “DemoGoogleSpreadsheet” and a backend database titled http://functions.js with the following code that I am trying to use to set up Zapier to “fire off a single Post request as JSON”.

I’m using the following URL: https://garymstark.wixsite.com/website-4/_functions/storerecords and I keep getting a (500) server error message. Any thoughts on how to fix this?

‘use strict’;
import wixData from ‘wix-data’;
import {ok, response} from ‘wix-http-functions’;

export function post_storerecords(request) {

return request.body.json ()
.then (body => {

let recordInsert = {
“title”: body.Headline,
“description”: body.Description,
“imageUrl”: body.ImageUrl,
“linkButtonText”: body.LinkButtonText,
“linkButtonUrl”: body.LinkButtonUrl,
“authorName”: body.AuthorName,
“email”: body.EMail
};

return wixData.insert (‘DemoGoogleSpreadSheet’, recordInsert)
.then(result => ok({body: JSON.stringify(result)}))
. catch (err => response({status: 500, body: err}));
}
);
}

  1. I see that Wix has an Airtable node module. I LOVE the plug and play template you showed to get the Google Sheets node module up and running. Is there a template available to get the Airtable node module working as well?

Thank you for all of your help!