How to add a file to a Softr database record using Make.com?

Ask the community
,
1

Hi,
Using make.com I want to upload a Google Doc to a “File” field in a Softr Database.
This is the Softr database table. “Contract” is a field of type File.

image
image3420×362 66.3 KB

This the Make process I’ve build. See here.

image
image1759×289 80.2 KB

This the configuration of the array aggregator

image
image679×554 52.9 KB

This the configuration of the Softr - Update Database Record module where I want to add the downloaded contract.

image
image679×554 52.9 KB

I’ve read that only public available documents can be uploaded to Softr file fields. Therefore I create the document in a Google Drive folder, which is shared to public. These created documents are accessable for everyone (see here for an example).

Note: we’re not using Google workspace, but the free Google Drive access.

Can anyone shed some light, to get this working?
Many thanks.
Dirk

2

Hey there - can you confirm that the Web view link variable you’re sending here is having for example this value:

https://docs.google.com/document/d/1p-pXcjsBcb0__VQbXIUhccxtuAtcbN7WxrNqRLDBd3c/edit?tab=t.0

If so, this isn’t directly a hosted URL to a file, but a Google Doc sharing link. You would need to use a variable that actually contains the file itself (e.g. a PDF file, or Docx, etc). For example:

https://ghgprotocol.org/sites/default/files/standards/ghg-protocol-revised.pdf

As you’ve just used the “Download a Document” step in Make, it’s very likely that there’s such a URL in the payload, could you check the payload this Google Doc action outputs?

3

Well, I’ve got

image
image817×510 51.2 KB

I don’t see any download link in the payload. Where to find/how to create this using Google Docs?

4

Maybe via the G Drive modules then?

Found this which seems to give more data than what you’re getting:

Wow, that thumbnail :sweat_smile: