How do I use the Mote Magic Link Add-on for Google Sheets?

The 'Mote Magic Link' is a fun and simple experiment to extend Mote's use. 

Installing the Add On

You should be able to find the Mote Magic Link in the Google Workspace Marketplace.

Using the Add On

Getting Started

Most simply, you can use the Add On to return the transcript of a Mote link. 

Only links with a transcript can be used with the Magic Link.

To use the Add on in this way, you will enter the function as shown below, and replace 'CELL_REF' with the cell that has your mote link

=GETMOTELINK(CELL_REF)

For example:

=GETMOTELINK(A2)

Why not try...

You can also add a prompt that will send your mote transcript to GPT 3.5. TO do this, add the prompt as follows:

=GETMOTELINK(CELL_REF,"Prompt text")

And... in 'Pro' mode, you can also simply speak your prompt as part of your mote recording by starting your mote with the phrase "Ask GPT to" and then start your voice message content with "Start".

For example, you could say: 

"Ask GPT to craft this feedback into a positive, friendly note, that starts with a 3 bullet point summary, complemented with emoji. Start. Hi Mary, I really enjoyed reading...."

Then, simply paste the link into Sheets, and add it to the function.

=GETMOTELINK(CELL_REF)