importing cell from Google Sheets

[NFT-Trader]

I have been trying to import a cell or cells from google sheets into my strategy without much success. Has anyone managed to figure this out? One option would be to export the cell from google sheets into a .csv file and have my script read this file, while the other that I see would be to directly access google sheet and scrape the data. On both ends I have been unsuccessful. Not looking to bring stock quotes just data that I want to assign into a variable within my script. Thanks in advance.

[bltdavid]

Are you authenticating yourself correctly to Google?
Are you using a service account or your own user account?
Are you sure these steps are working correctly?

https://developers.google.com/sheets...es/authorizing

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

Reading a .csv file can be relatively simple and can be vastly easier to code.
Which one are you wanting to achieve first?

https://stackoverflow.com/questions/...-into-an-array
https://stackoverflow.com/questions/...-c-with-header

[NFT-Trader]

Are you authenticating yourself correctly to Google?
Are you using a service account or your own user account?
Are you sure these steps are working correctly?

https://developers.google.com/sheets...es/authorizing

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

Reading a .csv file can be relatively simple and can be vastly easier to code.
Which one are you wanting to achieve first?

https://stackoverflow.com/questions/...-into-an-array
https://stackoverflow.com/questions/...-c-with-header

Thanks David, I have my reader working well within my script and I am able to scrape data from other sites as well but struggling with Google Sheets getting specific cells so authentication may be my problem at this stage. I will work on that to see what I can manage. All My Best

[NinjaTrader_Kate]

Hello NFT-Trader,

Thank you for your reply.

I would agree with bltdavid here. While accessing Google Sheets is not officially supported, going the CSV route would be simpler. I agree that you're likely running into an authorization issue with Google Sheets - I'd check out those links he provided.

Please let us know if we may be of further assistance to you.