If you encounter issues where LPagery does not find your Google Sheet, most of the times one of these two things are the problem:
- Your Google Sheet is not available via the link. Make sure that you share your Google Sheet and then use that link.
- The Google Sheet is actually an XSLX file (indicated by the “.XLSX” on the top left in your Google Sheet). Change this to a regular Google Sheet to fix this problem.