1/17/2024 0 Comments Use google sheets as rss reader![]() ![]() This product is brought to you by talarian.io, maker of YAMM, Form Publisher and Awesome Table, which are some of the most popular add-ons of the Google Workspace Marketplace. Please note that we recommend you write your letters to your grandmother by yourself with pen and paper, the slides are just provided as a cheeky examples of what can be achieved with this tool :) This is not covered by ChatGPT Plus/Pro subscriptions. You will need to insert your OpenAI or Anthropic api key. You only need to pay OpenAI's or Anthropic's API cost. This add-on is completely free to use while in beta. model (including fine-tuned models in Sheets™) In addition, this add-on will let you experiment easily with hyperparameters: managing and cleaning product catalogs for e-commerce stores (Shopify and Amazon) working on SEO metadata (titles, descriptions) working on ad copy (PPC, Google ads, Facebook ads) trying different versions of a prompt quickly classifying lists of reviews with sentiment analysis or feature categorization cleaning up lists of names, adresses, emails or companies, dates, currency amounts, phone numbers This add-on will help you achieve some tasks such as: GPT_TABLE to get a table of items from a prompt While exploring how to build an RSS reader, I stumbled across the idea of using Google Sheets to display RSS feed content. GPT_LIST to get multiple result in a column (one item per cell) GPT_SPLIT to split text semantically, such as by section, paragraph, sentence, customer… ![]() GPT_MATCH to match values from two columns GPT_TAG to apply tags to your spreadsheet content GPT_EDIT to edit your spreadsheet content Select Service Account and proceed forward by creating this service account. Go to Credentials and select Create credentials. GPT_FORMAT to sanitize your spreadsheet data into the same format Click on Enable APIs or Library which should take you to the library of services that you can connect to. GPT_SUMMARIZE to summarize your spreadsheet content GPT_EXTRACT to extract entities from your Sheets™ data GPT_CLASSIFY to classify spreadsheet content into a single category GPT_TRANSLATE to translate your spreadsheet content GPT to get the result of ChatGPT in a single cell This add-on brings ChatGPT and Claude AI power to Google Sheets™ by exposing many simple custom functions: Video tutorials: by Marc Andreessen as a "killer app": You can select the model you want depending on cost, latency and capability in the sidebars In Docs, the default model for all functions is now gpt-3.5-turbo-16k. In Sheets, the default model for all functions is now gpt-3.5-turbo. If ChatGPT was GPT for Chat, you can think of GPT for Sheets™ as SheetGPT. You can use it for all sorts of tasks on text: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining, etc Models available include OpenAI GPT-3.5 and GPT-4 as well as Anthropic Claude. It enables you to use ChatGPT and other generative AI models directly directly in Google Sheets™ and Docs™. GPT for Sheets™ and Docs™ is an AI writer for Google Sheets™ and Google Docs™.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |