You can use Awesome Table Connectors to export data from Shopify to Google Sheets by logging in with the Shopify connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Shopify connector.
On the Connect to Shopify screen, click Sign in with Shopify.
You are redirected to the Shopify login page.
On the Shopify login page, choose the login method you want to use.
Once you are logged in, select a store from which you want to export data.
Shopify will prompt you to install Awesome Table. Click Install app.Awesome Table informs you if your connection is successful.