Error: GoogleSheet.php - array_shift(): Argument #1 ($array) must be of type array, null given

[jasonmckinney66]

Description

Importing from Google Sheets with header and single row of simple data. FeedMe connects but throws error:

Steps to reproduce

1. Verified url format and key are working via Google Workspace Explorer
2. Added url with key to FeedMe.
3. Feed looks like: https://sheets.googleapis.com/v4/spreadsheets/1r4XVBK54osTdyyZedPcLlAb_7LFnyphEo1IoEYRnP7s?ranges='2022'&key=AIzaSyCXuTJxsI-t7IzLwcCrPsnjYT1qellXXXX

Additional info

• Craft version: 4.8.9
• PHP version: 8.0.8
• Database driver & version: MySQL 5.7.34
• Plugins & versions: FeedMe 5.4.0

[i-just]

Hi, thanks for reaching out! I believe your feed URL is not quite right. I have tried the following 2 examples:

• https://sheets.googleapis.com/v4/spreadsheets/<sheet_id>/values/Sheet1?key=<my_key> => works as expected
• https://sheets.googleapis.com/v4/spreadsheets/<sheet_id>?ranges=Sheet1&key=<my_key> => throws the error you’re seeing

The response from the Google Sheets URL has to contain the “values” key. Something along the lines of:

I hope this helps!

I will close this now, but please don’t hesitate to get in touch if you run into any further problems!