Importing Google Sheet from Google Drive

[jray8242]

I am trying to do the following.

1. Import a Google Sheet file from Google Drive.
2. Create a list from it.
3. Add list to TinyDB

I am getting a file not found error and not sure what I am missing.
Yes, I have searched and read a lot on this subject.
Thanks for the help.

[TIMAI2]

Is your Google sheet shared: Anyone can view ?

[ABG]

I see you are using a ReadFile block, feeding it a URL instead of a file name.

I usually expect people to use a Web component to get a file from the Web.

Is this a thing?

[jray8242]

Here is what I have.
This is a sample file.
Sample File

[jray8242]

That could be my problem.

I want to read the file via the WEB into a list and then add it to the TINYdb table.

[TIMAI2]

If we assume that in your google spreadsheet you have a sheet that is a table of data in columns and rows, and that sheet is the first sheet in the spreadsheet, use these blocks to return the data

If you then wish to store the data in a tinydb as a list do this:

[jray8242]

Tim,

I will try this method. Pertaining to calling the sheet, this is the link I get when grabbing it. I know notice you are using "=cvs" which is what I want to use.

This is my link and think I need to learn how to create the link for exporting a CSV file, that is if I am missing something.

I really do appreciate the help.

Here is my link..

dbRP

[TIMAI2]

Did you try my blocks, replacing your spreadsheet ID ?

[jray8242]

I will later. In a meeting right now. Multi-tasking.

Thanks again.

[jray8242]

Tim,

I have tried the following with no luck.

I understand the blocks but the problem I am having is the Google information.
This is the link for accessing the CVS file.

"Google Drive: Sign-in"

I changed the "view" to the "export" like in your example.

This is the link for the Google Sheet itself.
"https://docs.google.com/spreadsheets/d/15UYbBMrVWnNDLIkgWG3m9cmD1Udnm2ofSv0D-nt4Sv4/edit?usp=sharing"

I changed the "edit" to the "export" like in your example as well.

This is the error I am getting.

What am I failing to understand here? I know I am old, but this is really bugging me.

Thanks again for being kind to me and helping me to understand this. It's been a long time since I have done something like this.

[TIMAI2]

The first line of your url should be this, to your spreadsheet:

https://docs.google.com/spreadsheets/d/

Your spreadsheet is not shared so I cannot test the data download problem

(A different, more complicated approach is required if you want to directly access a csv file, use the google sheet)

[jray8242]

That was my fault. I have now made it public.

:Laser Marketing Jeremy - Google Sheets

[TIMAI2]

Working OK here:

Blocks

Screen

[jray8242]

Sweet! That worked. Part of my problem was I put in some bad syntax.

Thanks for the help. Now to add it to Tinydb.

Thanks, again !