June 24, 2019 at 9:47 pm #51550
Hello WP Google Maps Team,
I have found similar issues in forums but most of them do not elaborate on how to resolve the issue.
Similar forums that do not resolve my issue:
I am currently trying to upload a URL Google Sheets but I keep getting two different errors. Ultimately, I have to get the URL importing working because my project requires automatic importing; therefore, local and manual importing won’t work. I get this error even with the Example.csv file provided in the importing/exporting documentation page, link provided: https://www.wpgmaps.com/documentation/exporting-and-importing-your-markers/
If I open the Google Sheets file and publish the file, I get this link:
If I use this link, I obtain the following error message when attempting to import the URL file:
We couldn't establish what kind of data you are trying to import (is the header row missing?)
If I just use the shareable link by right-clicking on the CSV file, I get this error instead.
Error parsing JSON: Syntax error
If someone could help me resolve this issue, that would be greatly appreciated. Thank you for your time.
Attachments:You must be logged in to view attached files.June 25, 2019 at 9:05 am #51558
Thank you for getting in touch, sorry to hear you are experiencing issues with the plugin.
Regarding #1 – your CSV is correctly formatted, so we would have to have FTP access to your site in order to debug this. This would allow us to add a line of code to dump the data your server is receiving as it’s clearly not seeing the CSV as we are at our end.
Regarding #2, your server is attempting to parse the CSV as JSON. Again, we’d need FTP access to look into this, as it’s likely not receiving CSV data and therefore trying to parse in the default format, which is JSON.
Would access be permissible?
– PerryJuly 25, 2019 at 12:11 am #52569This reply has been marked as private.July 25, 2019 at 11:36 am #52594
That’s great, thank you, however we will need the hostname and/or URL to your page as well, please.
– PerryAugust 6, 2019 at 5:37 pm #53001
My website’s URL is
and the hostname is Bluehost.
Thank you for your time!August 7, 2019 at 11:57 am #53010
Your server is receiving the following from Google:
Sorry, the file you have requested does not exist.
Make sure that you have the correct URL and the file exists.
It looks like your server is unable to access that sheet.
Perhaps it works locally because we are both logged in to our respective Google accounts?
Could you try making the sheet publicly visible to anyone?
– PerryAugust 8, 2019 at 8:50 pm #53034
Sorry for not having the CSV files public, I mistakenly deleted the files and forgot to reupload them. Here is the link:
This the error message I get when using the link:
We couldn’t establish what kind of data you are trying to import (is the header row missing?)August 9, 2019 at 7:48 am #53038
This happens because your server is receiving a “Page not found” from Google, as opposed to the CSV data.
You’ll need to fix that in order for the server to be able to access your spreadsheet.
Please can you review your sharing settings for this spreadsheet to ensure your server can access the data, and not receive the “Not found” page?
– PerryAugust 15, 2019 at 9:30 pm #53304
I figured it out. I tried multiple sharing options but I must have missed the right setting options. Thank you Perry.
EduardoAugust 16, 2019 at 6:17 am #53307
We’re really glad to hear it, thanks again for your feedback – we’ll be adding a debugging feature to the Sheets integration so you can see what your server is seeing, so that this becomes easier to deal with in the future.
Is there anything else we can help you with?
You must be logged in to reply to this topic.