How to sync an access table with google sheets.

[itsmasum]

hello everyone.
I have a dental clinic management database made in access. And I have an IoT project that can display data from a google sheet. i want one of my access table to be always in sync with that google sheet as i want to display it in the IoT project screen. it's only a couple of rows and coloumns. i tried codes from chatgpt using google api key. tried google form response id. nothing seems to work. can you help me with it? thanks.

[June7]

Review https://answers.microsoft.com/en-us/msoffice/forum/all/import-or-link-to-google-spreadsheets-simple/9cd275e0-8006-433d-923c-dd20d23e8d06

[troywolf]

Review https://answers.microsoft.com/en-us/msoffice/forum/all/import-or-link-to- (https://answers.microsoft.com/en-us/msoffice/forum/all/import-or-link-to-google-spreadsheets-simple/9cd275e0-8006-433d-923c-dd20d23e8d06)bloxd io (https://bloxdio2.com)-google-spreadsheets-simple/9cd275e0-8006-433d-923c-dd20d23e8d06 (https://answers.microsoft.com/en-us/msoffice/forum/all/import-or-link-to-google-spreadsheets-simple/9cd275e0-8006-433d-923c-dd20d23e8d06)
I like this solution, but I don't understand "Set up Google drive so documents had a path in my local computer."

[June7]

Maybe this https://www.cnet.com/tech/services-and-software/how-to-make-google-drive-your-default-documents-folder/

[ternfs121]

Maybe this https://www.cnet.com/tech/services-and-software/how-to-make-google-drive-your-default-documents-folder/
thank you!