Pronunciation Link in A Spreadsheet

Is there a way to add a pronunciation link to a spreadsheet to hear the pronunciation of a word or phrase?

For example, I have a spreadsheet (Google Sheets) with a column for English words and phrases and a column with an automatic translation formula to Chinese. Of course not perfect so I have other columns with my own translation, notes, etc.

 =googletranslate(A1,"en","zh-TW")

Can I add another column that would automatic link to Google Translate or something to hear the pronunciation?

Note: I’ve seen some web and youtube examples with “=HYPERLINK…” where clicking on box in spreadsheet opens Google Translate to the word but none of them seem to work.

Possible with the hyperlink trick. Use a REST API

try https://pinyin-word-api.vercel.app

1 Like