Example: Google Sheets NPM

Amazing!!! Does it work both ways?

Hi guys! The get code button doesn't seem to be working for me. I must be doing something wrong! I've enabled the Google Sheets API and downloaded the configuration file. Then copied the text code into the text box and pressed enter. The enter doesn't seem to be doing anything- it just moves the text cursor to the line below, as you would expect on any word document.

I then create a new Sheet in Google docs and copy it's URL into the second text box and hit enter. Nothing really happens here either. After this the 'Get Code' button still doesn't seem to work for me. Could anyone enlighten me on what I'm doing wrong?

Heres a link to the page: https://leopoldtaylor.wixsite.com/mysite/configuration

And a screenshot of the code I've entered:

Hi everyone,

Is there a way to copy the elements in your example site (@Yisrael) into another Wix site without having to rebuild and redefine all the elements from scratch to connect to the page code?

I have installed the googleapis node module and copied and pasted the code for config and googleSheet jsw files to the into the backend site structure. Is adding new web modules to the backend and copy pasting the code the most effective way to do this?

I know zero JavaScript so am sure I'm missing something crucial! Just to be clear, all I need to do is to get this system to work on another Wix site.

Thanks in advance everybody!

This is amazing, got the example to work perfectly and just what I needed for my site but.............

Would anyone that fully understands how to take this example and implement it on a site be willing to do a video tutorial?

I have a site that already has a multistage form and database but am struggling on the transfer even with @Gal Morad @Yisrael (Wix) great work and explanations.

Sorry but being stupid!

Does the same procedure work for big-query?

Hello, I am having some problems with the "Get Code" button on the form, similarly to @leopoldtaylor , with the Developer console I have witnessed on submitting the Google Sheet URL this error:

I have already tried changing Permission and trying in Live and Preview Mode. Does anyone have any ideas?

This is the site link: https://cogestione2019.wixsite.com/test

Thank you in advance!

Thanks for this instructive example. I have two questions:

1. Why did you choose Other instead of Web Application for the app type.

2. How is the token refreshed if it expires.

hi,

thanks for great example.

how i can add timestamp for every submit?

I have tried find solution, i tried to write in google script, but this is not working, working only manual input in google sheets.

I be extra thankful, when you find time to help me.

@Yisrael (Wix) I was able to successfully utilize your example to connect to Google Drive. Thank you!

I have ran into a slight issue though. This may be more Google API related but I thought I would ask.

I have the following code that creates a folder. The folder is created successfully, however, the file.id is always null.

I would be grateful for your thoughts on why this may be happening.

export async function createFolder(folderName) {
    const authorizedAuthClient = await createAuthorizedClient();
 
    const drive = google.drive({version: 'v3', auth: authorizedAuthClient });

     let fileMetadata = {
         'name': folderName,
         'mimeType': 'application/vnd.google-apps.folder',
         parents: ['redacted']
     };

    let toCreate = {
        resource: fileMetadata,
        fields: 'id, name'
    };

    drive.files.create(toCreate, (err, file) => {
         if (err) {
            // Handle error
            console.error(err);
        } else {
            console.log('Folder ID: ', file.id);
        }
    });
}

Thanks,

Peter

For the newbies like me: actually I found a good reference via node-googleapis-installation in Wix, the following link, where all is really well explained:

https://github.com/googleapis/google-api-nodejs-client#readme

or better

https://apis-nodejs.firebaseapp.com/oauth2/index.html#typescript

https://developers.google.com/identity/protocols/OpenIDConnect

https://developers.google.com/oauthplayground/

More, I found also that you could realize an automatic Service-Service Authentication !!

Can someone help a total beginner to get started, here? I am technically savvy, but brand new to Corvid and Wix automation, and lacking context for this post. How does one access the "Google Sheet NPM" form, in the OP?

One question, is possible update on a Google sheet a collection of 500 or 1000 records with this method ?

Hi dear @Yisrael (Wix) ,

Thanks for the great code. It saves lots of time. :-) But still I have a question. After added the data to the google sheet (using your code) , is there any way to update it through the website..?

I mean using a dropdown menu, select & retrieve the data and update the selected data field.

Thanks in advance.

Chathuranga.

Thank you Yisrael! Sounds great!

How safe is this?

We are dealing with patients' information (ePEI) and using GSuite.

Could someone reach out the data during transfer from Wix to Gsuite?

We should be HIPAA compliant.

Thanks,

Hey guys,

Just thought you guys should know that the 'refreshAccessToken' is being deprecated now. Following is the message relayed during a call.

(node:1) [google-auth-library:DEP007] DeprecationWarning: The `refreshAccessToken` method has been deprecated, and will be removed in the 3.0 release of google-auth-library. Please use the `getRequestHeaders` method instead.