How do I add an audio file to my google sheet?

1

Hello,

I can’t figure it out… I have an audio file on my computer but I can’t upload it in the Google sheet.
When I put it on the drive it doesn’t give me a “.mp3” file.
I don’t understand how to get a “.mp3” link with my audio file.

Can you help please?

Thank you so much!

2

Did you share the file to get the public URL? Did you try the link with an audio component?

3

Yes the link is public, here it is but it’s not .mp3 : https://drive.google.com/file/d/1UcKpb7KncQY7QOJQke2pJc8GgQEUQ8YN/view?usp=sharing

What do you mean by “with an audio component”?

Thank you for the help Jeff!

4

The link works. Put it in your sheet and then add an audio component to play it in the app.

1 Like
5

Oh god, thanks Jeff… I have a chrome extension that was hiding the “+” sign in the top right corner so I didn’t know I could add components…

I lost so much time haha
Thank you so much for the help!

1 Like
6

Hello :slight_smile: I have the same question

The link -
https://drive.google.com/file/d/1KiyhYCagEctexV9IP-
aIWjltnp1BEpx1/view?usp=sharing

Public in google drive folder, opens as mp3.

I have added an audio component but the controls remain greyed out and nothing is working.

Thank you
Melissa

7

image
image1306×362 12.3 KB

Did you have any additional settings for your file?

I tried the link here and it works.

image
image2200×1226 105 KB

8

Thank you :slight_smile:

image
image339×658 18 KB

image
image716×119 9.03 KB

image

9

Does it work if you allow downloading?

10

It’s working now :smiley:D

1 Like