LOAD CSV & Google Sheets

(Michael McKenzie) #1

I came across this article by @rvanbruggen about using LOAD CSV. As stated in the blog, it in order for this to work, the spreadsheet needs to be accessible by anyone on the internet because Neo4j doesn't know how to handle the authentication.

My question is: has there been any improvements or updates that would permit connecting to a private Google Sheet?

Mass File Import from Google Drive
(Michael McKenzie) #2

I haven't had much luck yet navigating around the issue I get when attempting to import a google sheet directly. I get the following error:

Neo.DatabaseError.General.UnknownError: At https://docs.google.com/spreadsheets/d/1J5DbP_5g_bSwx903pg_TuJYOBjqWIycDv0A5JM2_TIY/export?format=csv&id=1J5DbP_5g_bSwx903pg_TuJYOBjqWIycDv0A5JM2_TIY&gid=1185833437 @ position 30192 -  there's a field starting with a quote and whereas it ends that quote there seems to be characters in that field after that ending quote. That isn't supported. This is what I read: '>
<div  class="c'

I am not sure to what exactly this is referring.

(Michael McKenzie) #3

I am even attempting to use the Sandbox with Google Sheets but the first page seems to fail in loading the initial command/query to start the tutorial. There is not "play" button to use the pre-populated command.

(Michael McKenzie) #4

Hazaa! Looks like I had my browser blocking cookies preventing me from importing into the database. Additionally, I had failed to adequately set my sheet to public so that I could access it for the LOAD CSV command.

Thanks to @ryan.boyd for helping me figure it out!

(Michael McKenzie) #5

I thought I had it figured out, but I seem to be running into some inconsistencies. Is anyone using Google Sheets with LOAD CSV regularly that can help me out?

(Michael McKenzie) #6

So I was able to figure it out after chatting with someone on the slack channel=:

  1. I was forgetting to include fieldterminator
  2. I had failed to set the file public

Problem solved!