CSV import to use images on my Gdrive

[Michael Ellyett]

I want to use CSV import to use images on my Gdrive

In the standard data example for CSV import the data looks like this:

Evan Miller,CFO,emi,Office 1,,m...@example.com,#dae8fc,#6c8ebf,,https://www.draw.io,https://cdn3.iconfinder.com/data/icons/user-avatars-1/512/users-9-2-128.png

Edward Morrison,Brand Manager,emo,Office 2,Evan Miller,m...@example.com,#d5e8d4,#82b366,,https://www.draw.io,https://cdn3.iconfinder.com/data/icons/user-avatars-1/512/users-10-3-128.png

I took one of the images (https://www.draw.io,https://cdn3.iconfinder.com/data/icons/user-avatars-1/512/users-10-3-128.png) and saved it as a test on my G Drive. I create a public link to it https://drive.google.com/open?id=1Gr1_xkF8YGuu-qb0ih9cvH9x4IVwzWCt. I then tried the import referencing this e.g. 

Evan Miller,CFO,emi,Office 1,,m...@example.com,#dae8fc,#6c8ebf,,https://drive.google.com/open?id=1Gr1_xkF8YGuu-qb0ih9cvH9x4IVwzWCt

Edward Morrison,Brand Manager,emo,Office 2,Evan Miller,m...@example.com,#d5e8d4,#82b366,,https://drive.google.com/open?id=1Gr1_xkF8YGuu-qb0ih9cvH9x4IVwzWCt

It doesn't work. Any help appreciated.

[Mate]

The image needs to be hosted on a public URL. It won't work if authentication is needed.