I actually just did this exact setup for a client a few weeks ago.
And yes, you are correct — unfortunately, you have to get a cloud drive involved to get the URL of the file to send to Airtable.
Here’s a screenshot of our setup: