[Bug]: getting error while connecting google sheet

[tarun-hexon]

Short description of current behavior

I tried to connect google sheets but i am getting this error

"KeyError: 'spreadsheet_id'"

Video or screenshots

Expected behavior

No response

How to reproduce the error

No response

Anything else?

No response

[tomhuds]

Can confirm this is not working
https://docs.google.com/spreadsheets/d/15b2ISpezOK-Jb9MunJh1xrGlhtaZKJTtvXmWlPQ9z3o/edit#gid=0

[tarun-hexon]

Not Working, getting same error.

…

________________________________ From: Tom Hudson ***@***.***> Sent: Monday, January 8, 2024 9:46 PM To: mindsdb/mindsdb ***@***.***> Cc: Tarun Suresh Kumar ***@***.***>; Author ***@***.***> Subject: Re: [mindsdb/mindsdb] [Bug]: getting error while connecting google sheet (Issue #8582) Can confirm this is not working https://docs.google.com/spreadsheets/d/15b2ISpezOK-Jb9MunJh1xrGlhtaZKJTtvXmWlPQ9z3o/edit#gid=0 image.png (view on web)<https://github.com/mindsdb/mindsdb/assets/34073127/1c859e6b-bdaa-4efb-9f0e-db6bf8fc007d> image.png (view on web)<https://github.com/mindsdb/mindsdb/assets/34073127/174c1c74-c764-4866-839a-ba63b49bffc1> — Reply to this email directly, view it on GitHub<#8582 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BEJTE3TKRVMTY6RMNOAYLPDYNQLUVAVCNFSM6AAAAABBOLOVZOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBRGM4TAOBTGA>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[ZoranPandovski]

@tarun-hexon is the sheet public?

[tomhuds]

@ZoranPandovski mine was public and I could reproduce the error

[tarun-hexon]

Yes it’s public Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: Tom Hudson ***@***.***> Sent: Tuesday, January 9, 2024 8:54:45 PM To: mindsdb/mindsdb ***@***.***> Cc: Tarun Suresh Kumar ***@***.***>; Mention ***@***.***> Subject: Re: [mindsdb/mindsdb] [Bug]: getting error while connecting google sheet (Issue #8582) @ZoranPandovski<https://github.com/ZoranPandovski> mine was public and I could reproduce the error — Reply to this email directly, view it on GitHub<#8582 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BEJTE3SFMHNMGR2JZCNJHMTYNVOL3AVCNFSM6AAAAABBOLOVZOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBTGI2TOMJQG4>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[parth-verma7]

Ya Actually I also tested it, it is always giving an error related to spreadsheet Id

Actually in sheets_handler.py the connection_data which is being received is null
Will try to fix this!!