Getting Data from Google sheets API to Variable

If you willing to try the Shortcuts way, there's an app you can purchase to read and write data to google sheets.