How to sync media files from Google Sheets to Library
See how Sked Social's sync of Google Sheets files to your Library works, and how to set it up.
How the integration works
When you connect Google Sheets, one of the things Sked can do is import a list of media files from a spreadsheet into a content collection in your Sked library.
It reads your spreadsheet as a list of file links — one file per row — and pulls each file into the collection you choose. It does not attach media to ideas, and it does not read the images or files that are pasted or embedded inside the sheet. It only follows direct file links(URLs) that your rows contain.
Use this when you keep a spreadsheet of asset URLs (for example, links to images or videos in cloud storage) and want those files in your Sked library.
What your spreadsheet needs
A link column. Sked looks for a column whose header is one of:
urllinkfilemediaasset
(The match is case-insensitive, and the first matching column wins.) Each row in that column should hold one direct link to a file — a URL that points straight at the file itself, ending in a file extension like .jpg, .png, .mp4, and so on.
An optional name column. If you also have a column headed name, title, filename or file name, Sked uses its value to name the imported file. Without it, the file keeps its own name from the link.
That's it — any other columns are ignored by this import.
What gets skippedSked imports what it can and quietly skips what it can't:
- A row whose link has no recognisable file extension is skipped (Sked can't tell what kind of file it is).
- A tab (worksheet) with no link column is skipped entirely.
- Blank rows are skipped.
So if some rows don't appear in your collection, check that their links point directly at a file and end in a normal file extension.
Where the files land
Every valid file link is imported into the content collection you pick when you set up the import. New rows you add to the spreadsheet are picked up automatically on the next sync (roughly hourly).
Setting it up
- In Sked, go to Settings → Integrations and open your Google Sheets connection.
- Find Import media files from a spreadsheet URL list.
- Pick the spreadsheet to read.
- Pick the content collection the files should land in.
- Save. The first sync imports every valid link; later syncs pick up new rows.
Frequently Asked Questions
Does this attach the images to my ideas?
No. This import puts files into a content collection in your library. It is separate from importing ideas from a Google Sheet (which turns each row into an idea).
My images are pasted into cells — will those import?
No. This import follows direct file links (URLs) in a column, not images embedded in the sheet. Put a direct link to each file in a url / link / file / media / asset column.
Some files didn't import — why?
The most common reason is a link that doesn't end in a recognisable file extension, or a row with no link. Check those rows' links point straight at the file.