GPT AI Functions for Google Sheets

FileDrop has multiple AI powered functions that users can use.

Please enable the paid features in the settings tab before using this feature.

GPTAI

A general function that can be used inside cells.

=GPTAI(“write a tweet about “&A4&”, include hashtags”)


GPTSHEETS

A general helper function for helping inside Google Sheets that can be used inside cells.

=GPTSHEETS(“convert the numbers in “&A4&” to words”)


GPT_EXTRACT

This function can be used to extract data from a cell like emails, websites, names, phone numbers etc.

=GPT_EXTRACT(“extract name from “&B2&”, return the result without other text”)


GPT_ANALYZE

This function can be used to analyze the data in a cell, analyze sentiment, rating responses and more.

=GPT_ANALYZE(“analyze the cv in “&B2&”, I am hiring a marketing assistant, it must have social media experience, rate it 1 to 5, summarize in maximum 20 words “)