Get audio file from openAI or Google drive to Airtable

I am using OpenAI to create from a text in Airtable an audio file. I need this file to be back to Airtable.

When using Edem for this task, I got a URL and file name.

When using OpenAI text to Audio I got an MP3 file. I am able to upload it to Google drive but when I send it back to Airtable with the module get a shareable link,I don’t get the audio file but a kind of text file. How can I get the MP3 file directly to Airtable ?

Thanks for your help.

Welcome to the Make community!

How is this done?

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes

attached the blueprint, and below the output from the Google drive module before the Airtable Module update

blueprint.json (427.4 KB)

[
{
“kind”: “drive#permission”,
“id”: “18349724883664069875”,
“type”: “user”,
“emailAddress”: “xxx@xxx.org”,
“role”: “owner”,
“displayName”: “xxx xxx”,
“photoLink”: “https://lh3.googleusercontent.com/a/xxxxxxx
-rxbP54zQt3KccFat3T3TqQliyKrCL1mG9Zu-s=s64”,
“deleted”: false,
“pendingOwner”: false,
“shareLink”: “Newsletter #13.-Main Part.mp3 - Google Drive
}
]

I was able to do it by using 0-CodeKit

Even better: I upload to google drive, I create the shareable link and in Airtable for the file URL I put:

https://drive.google.com/uc?export=download&id={{xx.id}}

Thisis the direct link to download a file. xx is the Google Drive Module to UPLOAD the file, it gives a URL, the field is FILE ID, but be careful, it is the FILE ID from the upload module not the Shareable Link Module. Works like a charm!

4 Likes

Hey there @Pascal :wave:

just wanted to pat you on the back for the great job you did while figuring out this puzzle. Great to see you were able to find a solution with some assistance from @samliew :clap:.

Thank you very much, for sharing your insights with us. We appreciate you keeping us in mind and coming back here. This way our community stays tidy and neat for others as well as for us :pray:

Keep up the great job! :gift:

1 Like