Google spreadsheet

You’re missing the key attribute. This is wrong:

[gdoc “my Google spreadsheet url”]

This is right:

[gdoc key="https://example.com/"]

I used this link: [gdoc key=”https://drive.google.com/file/d/1b1G0m3UYmD9OcUgKdA7gOCLoycSDxeNv/view?usp=sharing/%5D

Could be the Theme storefront and woocommerce the problem?

That is not a Google Sheet link, so it is not expected to work.

The first was from the google acmes setting.
This link was from the Google Excel page:
[gdoc key=”https://docs.google.com/spreadsheets/d/1UdXxKgPs_Xs5FKr_XJ3g7nNQhsDRyrjcutO7wvoKJKg/edit#gid=0/%5D

I don’t find any other link for the sheet.
I get always the message File can’t be open and a standard Google link:drive.google.com/start/apps.

I found my mistake, now it works.
Thank you for your fast support.

One more question
Is it possible to use a shortcode to query my Google Spreadsheet and display only the rows from the logged in wordpress user (like: [gdoc key=”ABCDEFG” query=”where ID = logged in user”]?

This plugin has existed for almost ten years. Please look for answers to your questions before you post here. Your question has almost certainly been answered before.