google sheet integration (need instraction)
# 🤝helpg
green-table-87234
06/23/2024, 7:11 AMI'd appreciate advice how to use google sheets integrations (as there is no docs). I'm trying to figure out how to Append Values. What do I need to write in Range and Execute to make it work. I tried all possible combinations and couldn;t find a right one
https://cdn.discordapp.com/attachments/1254332954176520203/1254332954415599616/Screenshot_2024-06-23_at_10.11.06.png?ex=66791c18&is=6677ca98&hm=fd0a40a387e3b28505c108a5f8d0451c566a04e587a2849f32151ba6b462df33&
f
fresh-fireman-491
06/23/2024, 8:24 AMHey there,
I don't believe that the integration was meant to be public right now, but a range could look like
A1:C5g
green-table-87234
06/23/2024, 8:27 AMDo you know what I should write in Execute block ?
f
fresh-fireman-491
06/23/2024, 8:28 AMI don't think you need to write anything 🙂
fresh-fireman-491
06/23/2024, 8:28 AMWhat does it show, when you just use the range
g
green-table-87234
06/23/2024, 9:28 AMIf I don't write anything, how would I pass the data which I need to append?:) Anyway even without writing anything I get an error that required key values is not specified. I tried to specify value in Execute window, but it resulted in the same error. overall it'd be nice to have docs how to use this integration. Other functions like GetValues or AddSheet work fine, but other are just confusing because it is not clear how to use them
f
fresh-fireman-491
06/23/2024, 10:48 AMI don't think it's meant to be used right now so that is most likely why it doesn't have any documentation
g
green-table-87234
06/23/2024, 12:19 PMgot ya, are these integrations gonna be available soon?
f
fresh-fireman-491
06/23/2024, 12:25 PMThey haven't given a timeline
l
limited-pencil-78283
06/24/2024, 1:20 AM@green-table-87234 is the integration itself working?
I am getting an error 500 on the integration page.
I tested with a python code and the same credentials work
g
green-table-87234
06/24/2024, 3:19 AMYes integration works. Make sure you open service account on google cloud and added email from json file as editor of your google sheet
l
limited-pencil-78283
06/24/2024, 3:21 AMI do have a service account, it works in my python code, but fails in Botpress
limited-pencil-78283
06/24/2024, 3:22 AMscope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
json_keyfile = '{
"type": "service_account",
"project_id": "sks",
"private_key_id": "",
"private_key": "-----BEGIN PRIVATE KEY-----\\n-----END PRIVATE KEY-----\n",
"client_email": "sks@sks.iam.gserviceaccount.com",
"client_id": "",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/sks%40sks.iam.gserviceaccount.com",
"universe_domain": "googleapis.com"
}'
limited-pencil-78283
06/24/2024, 3:23 AMI have all the details, this works perfect using python
g
green-table-87234
06/24/2024, 6:05 AMstrange) everything seems right in JSON. Try to make sure that all these steps are completed. Integration definitely works for me
https://cdn.discordapp.com/attachments/1254332954176520203/1254678702265073704/Screenshot_2024-06-24_at_9.03.54.png?ex=667a5e19&is=66790c99&hm=b47f1bc80cedd61a6d088a32c833822f70f4e2d999e51ae81b271cc406b7cc93&
l
limited-pencil-78283
06/24/2024, 9:25 AMyou see the private key has to be entered with the -----BEGIN PRIVATE KEY----- the new line entire \n etc. it got accepted, but I cannot use it, the implementation does not seem complete
g
green-table-87234
06/24/2024, 9:30 AMyou are right about private key, you need a whole thing. It's true that implementation is not complete, I can use 3 out of 6 functions it offers. The most relieble method is using make.com to update google sheets
2 Views