google drive integration question

Hi, I need to upload csv file to the google drive. I see there is some new integration tab on apify now, so I have some questions. Sadly there is a lot of settings but no documentation.
Is it possible to upload via this integration file from the key value store?
I have managed to convert csv file to json then push it to the dataset and then push it via the integration to the drive but there are some issues.

I do not know how to preserve the filename.
converting csv to json change the data a little.

I know there is actor for uploading to the gdrive but I like that with integration there is google sign in button so I do not need to care about permissions.
Thanks for suggestions

HonzaSOP•9/22/23, 1:26 PM

I have tried the actor https://apify.com/onidivo/google-drive and it has error while authorization. . Anybody is successfully using this actor?

Apify

Google Drive · Apify

Transfer files between Apify's key-value stores and Google Drive.

HonzaSOP•9/26/23, 7:22 AM

So nobody really knows how the integration on apify works?
In the end I have uploaded the file to the gdrive directly from the actor, without any integration or any special gdrive actor.

Oleg V.•10/3/23, 1:20 PM

Try to use new google account.
It works only for some people depending on security settings and country of that account.

We have info about here for example:
https://apify.com/lukaskrivka/google-sheets#authentication-and-authorization

Apify

Fast Google Sheets import and export tool · Apify

Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.

HonzaSOP•10/4/23, 2:58 PM

Using new google account is not really a solution. As I am able to push the file to the drive via apify integration tab cannot be the actors modified to use same authorization?

HonzaSOP•10/4/23, 3:04 PM

Is there some plan to update the sheet and drive actor to use service account for authorization with token? That works for me every time but then I cannot use the actors.

Oleg V.•10/5/23, 10:30 AM

@HonzaS
AFAIK We have in plans to add nicely working integration. But can't tell about the exact time)