How to access/set up for Scheduled Task to google drive?

[geoffdude]

Hello,

I'm trying to set up an automated task to append a table every day from a google doc on my google drive.. but I'm lost.

I've created the google OAuth 2.0 client ID and got the  Client Id Number and Client Secret info .. then I created a new Authentication in my app using that info.

I then went to Tools > Scheduled Task > New Site but I don't see "google drive" as an option from the drop-down list.

And here we are .. I'm clueless on how to proceed. Any and all help would be greatly appreciated.

Thx kindly.

[TsiBiRu]

Hi @geoffdude,

I've just tried creating a new site, to link to my google drive and I was able to successfully create one without any issue. Kindly try to do the steps below, those are the steps that I've did in configuring my new Site to link up with my google drive.

1. Click on 'Tools' , then click on 'Scheduled Tasks' http://prntscr.com/lv5ygc

2. You should be redirected on a new page, click on Sites http://prntscr.com/lv5yqz

3. Click on 'New Site' http://prntscr.com/lv5z3q

4. Click on 'Type' drop down-menu http://prntscr.com/lv5zgm

5. Then select 'Google Drive' http://prntscr.com/lv5zkq

6. A new form will appear http://prntscr.com/lv600t , I will suggest to open a new tab first in your browser then log in to your Google account

7. Click on the 'Authorize' button http://prntscr.com/lv608h

8. A new window will appear, and click on your google account https://prnt.sc/lv60je , then click on 'Allow' http://prntscr.com/lv60yl

9. On the 'Name for this Site' you can name it anyway you like , but on the 'Directory(folder)' it should be the same with the folder name in your Google drive.

10. Then Click on 'Test Connection' http://prntscr.com/lv61ya

11. When everything is working just click on the 'Create' button, and you should be able to see your newly create Site http://prntscr.com/lv62mq

If you will encounter any issue just update this thread so that we can help you right away. 

By the way, if you will still encounter the same issue. May I know your account / subscription Plan please.

Hope this helps.

Regards,

TsiBiRu

[geoffdude]

1 hour ago, TsiBiRu said:

Hi @geoffdude,

I've just tried creating a new site, to link to my google drive and I was able to successfully create one without any issue. Kindly try to do the steps below, those are the steps that I've did in configuring my new Site to link up with my google drive.

1. Click on 'Tools' , then click on 'Scheduled Tasks' http://prntscr.com/lv5ygc

2. You should be redirected on a new page, click on Sites http://prntscr.com/lv5yqz

3. Click on 'New Site' http://prntscr.com/lv5z3q

4. Click on 'Type' drop down-menu http://prntscr.com/lv5zgm

5. Then select 'Google Drive' http://prntscr.com/lv5zkq

6. A new form will appear http://prntscr.com/lv600t , I will suggest to open a new tab first in your browser then log in to your Google account

7. Click on the 'Authorize' button http://prntscr.com/lv608h

8. A new window will appear, and click on your google account https://prnt.sc/lv60je , then click on 'Allow' http://prntscr.com/lv60yl

9. On the 'Name for this Site' you can name it anyway you like , but on the 'Directory(folder)' it should be the same with the folder name in your Google drive.

10. Then Click on 'Test Connection' http://prntscr.com/lv61ya

11. When everything is working just click on the 'Create' button, and you should be able to see your newly create Site http://prntscr.com/lv62mq

If you will encounter any issue just update this thread so that we can help you right away. 

By the way, if you will still encounter the same issue. May I know your account / subscription Plan please.

Hope this helps.

Regards,

TsiBiRu

Thx, but as I noted above, I don't get "Google Drive" as a selection at all in the 'Type' > Drop-Menu. .. which is where I get stuck.

All I get for choices are:
- Http
-Https
- FTP
- FTPS
- SFTP
- SCP
- Amazon S3

 

Thxs though very much for trying to assist.

Geoff

[TsiBiRu]

Hi @Geoff,

That is weird, I have the following items in my drop-down http://prntscr.com/lv6pax

I'm sorry to know that you are still having this issue, I think it would be best if you contact Caspio's support team. I think they can add / configure this, so that you will have Google Drive in your drop-down. Once they have added it, you can just use the steps above.

No worries, it is my pleasure assisting my fellow Caspio user.

Regards,

TsiBiRu

[geoffdude]

Yeah .. I'm confused too. It seems like a straight forward process, but has turned out to be very frustrating.

Still hoping for some answers here from local Dev. folks.

Thx again.

[Vitalikssssss]

Hi @geoffdude,

The desired type of repositories might be unavailable if your account has a legacy plan.

You should switch to the latest Caspio plan in order to have the desired options. 

Hope this helps.

Regards,

vitalikssssss

 

[geoffdude]

Thx .. that's what I'm discovering right now... none too happy about that too. Thx though.

[geoffdude]

OK .. I got the proper update to the admin tool to allow me to use google drive ... BUT, what type of google doc (note, not actual file) can be used for automated updates? None that I can determine.

There is a HUGE ISSUE with using a true google doc / spread sheet generated by google drive. Caspio doesn't allow a direct connection to a google doc (which in it's essence hasn't a true file type). What the heck? How to reconcile this?

Also, if you upload a true excel sheet from your 'puter into google drive, and connect Caspio to it with the task tool, Caspio asks you for the directory path/file name, like this; ("directory/somefile.xls") but .. if that excel file is imported into google drive, then any update you make to it within google drive (to somefile.xls) creates a new version of the "file" in the directory as a new google spread sheet .. and the original .xls file which is linked to Caspio via scheduled task NEVER actually gets updated... which then results in the targeted Caspio table to also not get updated.

As example; lets say you wanted to update the imported excel file on GD 6 times in one day .. the original .xls file NEVER updates, the changes instead generates dated-timed clone files .. you'll end up with 6 versions of the data spread sheet for the date the original .xls file was updated. ???

OMG .. this so very frustrating.

Any ideas anyone?

Thx