If your Google workbook is locally-saved, consider converting it to Excel.  You could then use VBA automation, which allows Office apps to manipulate one another's data (local data only).  You could then change Excel data from Access, or Access data from Excel.  This would be the easiest way to go about it, with the necessary VBA skills.

If your Google workbook is online, then you would have to pay for additional services or tools, such as Microsoft Power Apps, a subscription service that costs $5 per user per app per month for its cheapest plan that is made for exactly this kind of thing: connecting and controlling various online and local data sources together.