Q: Hi Yaro,
I recently revisited a question that struck me as particularly astute, especially in the context of ...
our work with clients and specific projects. It revolves around the notion of managing API keys at a sheet level rather than at an account level.
The ability to allocate API keys at a sheet level presents a significant advantage. It empowers us to precisely track API costs associated with individual projects, which is paramount for effective project management. As you know, in our era of automation, the need to constantly alter API keys tied to Google Sheets seems counterintuitive.
Your tool, undoubtedly, stands out for its capability to harness the optimal AI platform in terms of both cost and performance. However, introducing the functionality to manage API keys at the sheet level would elevate it to unparalleled heights.
Might it be feasible to incorporate this feature into your development roadmap?
Thank you very much for feedback! - Open AI recently added tracking billing per key. So you can track it on OpenAI dashboard - section Billing so far. - I have added this feature into backlog, if there will be more requests for this feature, i will prioritize it.
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Or use Google Chrome extensions like: https://chromewebstore.google.com/detail/ai-chatgpt-lead-generatio/elgfcjbemdchphggeegglnmjoagoeial?hl=en&authuser=0
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Can I use it in any sheet? Can it be used on existing sheets? Is it an add on linked to my google account? Or I need to be copying a base template sheet to have access to formulas?
- It will be linked to your account - You can use the add-on in all sheets that are available for modifications to your account - Everybody who has subscription to the add-on also can use modified functions and call them during team work.
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Do the keys go at a sheet level or account level?
Can I use it on a sheet of a client, with my api key, and then have unique api keys per sheet per client to track consumption? If I added it to a sheet, can other users editing that sheet use the formulas?
"the keys go at a sheet level or account level?" - it used on account level that allows you dont set up it every time. Just one time set up and use.
"Can I use it on a sheet of a client, with my api key, and then have unique api keys per sheet per client to track consumption" - if we are talking about Open AI vendor, they have possiblity to track billing per key, from add-on side - you need just to -resetup every time the key.
"I added it to a sheet, can other users editing that sheet use the formulas?" - You can share the sheet as usual document, there are 2 buttons like: replace all /selected gpt functions with results - If you want to allow them use the gpt formulas, they should have subscription to the add-on and than - yes
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
It is not just connector. There are a lot custom functions that speed up you in Google Sheets.
There is implemented complex actually functions for replacing your 1 and 2 dimentional response function into text, to dont allow re-execute the queries again. Also it allows to use other Google Sheets functions to process the results.
+ A lot web scraping functions to fetch content and tags from web
"Do we have to pay for each Query " - it depends on your ai model vendor.
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
I have a GPT formula in 10 columns. If I add data, 1000 GPT formulas will run. What does your tool do to avoid timeouts, throttling of requests, and retries for failed requests?
- The current add-on (GPT, Gemini, Claude, Mistral for Sheets, by docgpt.ai) makes direct call from formular without any middle software. So it is the fastest way to generate response from AI. - To refresh failed formals - you can just refresh the page and Google Sheets will re-request them. (if you dont replaced AI functions with result - using built-in buttons for that inside the add-on)
There is no any limitations to count requests per minute/day/month from side add-on. Limitation only exist from OpenAI side or another AI model that you are going to use.
If we are talking about GPT, there are limits based on your Tier, that depends on how long the account exist, how much did you spent.
There are some other plans that use my enterprise key, where the maximum Tier and lowest limitations. It is connected to other plans that has subscription .
Feel free to ask anything else
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Thanks for the clarification! Are there any plans for some functionality like a "safe mode" that will run until all requests are successfull, and avoids most timeouts / bypasses the 30-second runtime limit for custom functions in Google Sheets / and automatically throttles openai to avoid timeouts etc
"bypasses the 30-second runtime limit for custom" - it is restriction from Google Sheets platform, that we cannot manage.
Probably it could be resolved by custom buttons like: 0. "Replace successfully executed functions" 1. "Recalculate error cells"
But be aware there are restrictions from AI vendor providers also. So probably you will need to use diff accounts with max tier.
Q: Looks like a great product thank you!
In the past, I have gotten from OpenAI , "I cannot extract or browse the web". DO certain LLM libraries don't allow this? Also, Do certain Functions NOT Need to go to a External LLM? like Extract Email, that could be a internal Regex Script hopefully.
You can use =GPT_EXTRACT() function for extracting some data from data :)
Or use customer prompt like =GPT/Mistral/Gemini/Claude("Extract email form the text:", A1)
- For accessing to the WEB, you can use following built-in functions in current add-on: WEB SCRAPPING: =WEB_URL("https://docgpt.ai") =WEB_TITLE("https://docgpt.ai") =WEB_DESCRIPTION("https://docgpt.ai") =WEB_H1("https://docgpt.ai") =WEB_H2("https://docgpt.ai/") =WEB_HEADINGS("https://docgpt.ai") =WEB_PARAGRAPHS("https://docgpt.ai") =WEB_URLS_DATA(A37:A39)
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
"About web scraping, which model can/should I choose? Or do you scrape and then pass it on to gpt/Mistral/Gemini/Claude?"
Web scrapping does not use any AI model. It makes direct GET requests to the links. it supports query params and any long of uri.
You can make using the follow flow for example - i want to rephrase competitors titles, descriptions or h1,2 tags: 1. Make =WEB_TITLE("https://docgpt.ai") 2. Click on button on the sidebar - Replace selected function (and select current cell with result) 3. Thits button will replace your function with the text result 4. After that in a new cell write =GPT("rephrase title for better click rate", A1). Where A1 is text result of prev fetched title
Thanks Yaro for the reply on "Web scrapping does not use any AI model."
I just do not really understand WHO scrapes the website. Is this a inbuilt function of Google Sheets, or is it you/a function of DocGPT (if yes any limits?), or takes scraping place from my IP adress? Also are the any options like residential proxies offered or recommended if the scraping is blocked (which may happen if you scrape hundreds of webpages in short time).
"I just do not really understand WHO scrapes the website. Is this a inbuilt function of Google Sheets, or is it you/a function of DocGPT (if yes any limits?)"
I have implemented all functions via native code for Add-Ons to provided the best possible performance. So there is no custom "middle server".
This Add-On functions are executed in cloud of Google. which could use some period of time the same external ip and often changed.
To have as diff as possible, just refresh the page with spreadsheet as often as possible. ( it will rebalance your requests to diff server "pods" )
There are limitations only for amount calling functions for Google Sheets/ per account. I do not remember how much, but if you are not going to ddos someone, you should not to reach them :)
Q: 1) When scrapping the content of the webpage, does it get everything or just the main contents - I know most ...
scrappers would just get everything including useless sidebars, menu nav, etc.
2) Are you able to do a google search and get top 10 results and scrape?
A: Hi! 1) About scraping - There is functions for getting specific tags like h1,h2, title, description. (like WEB_H1....) - Also there is function for getting whole content like: WEB_URL
2) About google search. i have planned this function soon, but it will use official API from Google that is paid (also needed to provide api key), their cost about 0.01$ per request. I dont like use "black" workarounds for scraping google, they are very unstable.
Let me know if you are interested in this func, i will prioritize it in backlog
There are following functions for scraping: WEB SCRAPPING:
=WEB_URL("https://docgpt.ai")
=WEB_TITLE("https://docgpt.ai")
=WEB_DESCRIPTION("https://docgpt.ai")
=WEB_H1("https://docgpt.ai")
=WEB_H2("https://docgpt.ai/")
=WEB_HEADINGS("https://docgpt.ai")
=WEB_PARAGRAPHS("https://docgpt.ai")
=WEB_URLS_DATA(A37:A39)
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Google Sheets works this way as you mentioned. So due to that the Add-On has two buttons: - Refresh Selected functions (it replaces selected cells with actual text) - Refresh All functions (it replaces all add-on's functions with the actual text on the spreadsheet
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Currently we planned in dev sprint to deliver supporting classic Relational Database that works with JDBC (Posgress, Mysql, AWS Redshift, Hive-jdbc driver)
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Currently we planned in dev sprint to deliver supporting classic Relational Database that works with JDBC (Posgress, Mysql, AWS Redshift, Hive-jdbc driver)
Currently it has image recognition: you can use =GPT_IMAGE(url, prompt)
but we have planned in sprint for image generation with other ai models
Q: How does this compare to Sheets Magic (doing very very well in Appsumo) and also GPT for Work.
Both are very established and well known. Both are very good as far as I know.
I'm sure many people would be asking you about this.
Also, what are our plans for your product. I don't expect it to be as good or established as the former 2, so would like to know your plans and roadmap. Thanks.
- GPT, Gemini, Mistral, Claude for Google Sheets (current product) supports more AI models (Gemini, Mistral, Claude), has less price, more reviews in Workspace Store, and higher rating. - Current product also - support WEB Scrapping functions - Your mentioned products has worse functionality.
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Documentation about creation api keys for Claude, Mistral, Gemini: https://docgpt.ai/docs/gpt-for-sheets/set-up-openai-api-keys Specifically for Claude (Anthropic) and Mistral, please scroll down there will be 2 sections
Yes! There are 2 buttons for replacing formulas with text results. - only selected cells - whole spreadsheets
Share
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can I use this to analyze a prior year banking google sheet where I added categories to each bank ...
traansaction description and then providfe this years transaction descriptions and have it tag the learned categories?
Yaro_DocGPT_AI
May 15, 2024A: Hello!
Yes you can.
There is even specific function for categorization: =GPT_CLASSIFY("banana", "fruit, vegetable")
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Hi Yaro, I recently revisited a question that struck me as particularly astute, especially in the context of ...
our work with clients and specific projects. It revolves around the notion of managing API keys at a sheet level rather than at an account level.
The ability to allocate API keys at a sheet level presents a significant advantage. It empowers us to precisely track API costs associated with individual projects, which is paramount for effective project management. As you know, in our era of automation, the need to constantly alter API keys tied to Google Sheets seems counterintuitive.
Your tool, undoubtedly, stands out for its capability to harness the optimal AI platform in terms of both cost and performance. However, introducing the functionality to manage API keys at the sheet level would elevate it to unparalleled heights.
Might it be feasible to incorporate this feature into your development roadmap?
Looking forward to your thoughts on this matter.
Yaro_DocGPT_AI
May 15, 2024A: Hi Navid!
Thank you very much for feedback!
- Open AI recently added tracking billing per key. So you can track it on OpenAI dashboard - section Billing so far.
- I have added this feature into backlog, if there will be more requests for this feature, i will prioritize it.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can this bulk scrape/read linkedin profiles?
Yaro_DocGPT_AI
May 15, 2024A: you can get metatags for Linkedin.
Or use Google Chrome extensions like: https://chromewebstore.google.com/detail/ai-chatgpt-lead-generatio/elgfcjbemdchphggeegglnmjoagoeial?hl=en&authuser=0
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Hi!
Can I use it in any sheet? Can it be used on existing sheets? Is it an add on linked to my google account? Or I need to be copying a base template sheet to have access to formulas?
Yaro_DocGPT_AI
May 15, 2024A: Hi!
- It will be linked to your account
- You can use the add-on in all sheets that are available for modifications to your account
- Everybody who has subscription to the add-on also can use modified functions and call them during team work.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
You can use this add-on in any spread/tab where your account has access to modify the sheets and call functions
Q: Is this tool able to scrape Youtube for video titles, H1, H2, etc?
Yaro_DocGPT_AI
May 15, 2024A: For scrapping specifically youtube needed more complex solutions like selenium, phantom js etc (allows to load js code)
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can I run the formulas in =ARRAYFORMULAS ?
Yaro_DocGPT_AI
May 15, 2024A: You can use any Google Sheets built in formulas with the provided functions by the add-on.
Specifically ARRAYFORMULAS - i have just checked - it works
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Do the keys go at a sheet level or account level?
Can I use it on a sheet of a client, with my api key, and then have unique api keys per sheet per client to track consumption? If I added it to a sheet, can other users editing that sheet use the formulas?
Yaro_DocGPT_AI
May 15, 2024A: Hey Jota!
"the keys go at a sheet level or account level?" - it used on account level that allows you dont set up it every time. Just one time set up and use.
"Can I use it on a sheet of a client, with my api key, and then have unique api keys per sheet per client to track consumption" - if we are talking about Open AI vendor, they have possiblity to track billing per key, from add-on side - you need just to -resetup every time the key.
"I added it to a sheet, can other users editing that sheet use the formulas?"
- You can share the sheet as usual document, there are 2 buttons like: replace all /selected gpt functions with results
- If you want to allow them use the gpt formulas, they should have subscription to the add-on and than - yes
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Do we have to pay for each Query ?
(It seems that your tool just bring AI API connector)
Yaro_DocGPT_AI
May 15, 2024A: Hi Romain!
It is not just connector.
There are a lot custom functions that speed up you in Google Sheets.
There is implemented complex actually functions for replacing your 1 and 2 dimentional response function into text, to dont allow re-execute the queries again. Also it allows to use other Google Sheets functions to process the results.
+ A lot web scraping functions to fetch content and tags from web
"Do we have to pay for each Query " - it depends on your ai model vendor.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: I have a sheet with 100 rows and 20 columns.
I have a GPT formula in 10 columns. If I add data, 1000 GPT formulas will run. What does your tool do to avoid timeouts, throttling of requests, and retries for failed requests?
Yaro_DocGPT_AI
May 15, 2024A: Hi buddy!
- The current add-on (GPT, Gemini, Claude, Mistral for Sheets, by docgpt.ai) makes direct call from formular without any middle software. So it is the fastest way to generate response from AI.
- To refresh failed formals - you can just refresh the page and Google Sheets will re-request them. (if you dont replaced AI functions with result - using built-in buttons for that inside the add-on)
There is no any limitations to count requests per minute/day/month from side add-on.
Limitation only exist from OpenAI side or another AI model that you are going to use.
If we are talking about GPT, there are limits based on your Tier, that depends on how long the account exist, how much did you spent.
There are some other plans that use my enterprise key, where the maximum Tier and lowest limitations. It is connected to other plans that has subscription .
Feel free to ask anything else
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Verified purchaser
Thanks for the clarification! Are there any plans for some functionality like a "safe mode" that will run until all requests are successfull, and avoids most timeouts / bypasses the 30-second runtime limit for custom functions in Google Sheets / and automatically throttles openai to avoid timeouts etc
"bypasses the 30-second runtime limit for custom" - it is restriction from Google Sheets platform, that we cannot manage.
Probably it could be resolved by custom buttons like:
0. "Replace successfully executed functions"
1. "Recalculate error cells"
But be aware there are restrictions from AI vendor providers also. So probably you will need to use diff accounts with max tier.
Q: Looks like a great product thank you!
In the past, I have gotten from OpenAI , "I cannot extract or browse the web". DO certain LLM libraries don't allow this?
Also, Do certain Functions NOT Need to go to a External LLM? like Extract Email, that could be a internal Regex Script hopefully.
Yaro_DocGPT_AI
May 15, 2024A: Hi Sean!
You can use =GPT_EXTRACT() function for extracting some data from data :)
Or use customer prompt like =GPT/Mistral/Gemini/Claude("Extract email form the text:", A1)
- For accessing to the WEB, you can use following built-in functions in current add-on:
WEB SCRAPPING:
=WEB_URL("https://docgpt.ai")
=WEB_TITLE("https://docgpt.ai")
=WEB_DESCRIPTION("https://docgpt.ai")
=WEB_H1("https://docgpt.ai")
=WEB_H2("https://docgpt.ai/")
=WEB_HEADINGS("https://docgpt.ai")
=WEB_PARAGRAPHS("https://docgpt.ai")
=WEB_URLS_DATA(A37:A39)
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
About web scraping, which model can/should I choose? Or do you scrape and then pass it on to gpt/Mistral/Gemini/Claude?
"About web scraping, which model can/should I choose? Or do you scrape and then pass it on to gpt/Mistral/Gemini/Claude?"
Web scrapping does not use any AI model. It makes direct GET requests to the links. it supports query params and any long of uri.
You can make using the follow flow for example - i want to rephrase competitors titles, descriptions or h1,2 tags:
1. Make =WEB_TITLE("https://docgpt.ai")
2. Click on button on the sidebar - Replace selected function (and select current cell with result)
3. Thits button will replace your function with the text result
4. After that in a new cell write =GPT("rephrase title for better click rate", A1). Where A1 is text result of prev fetched title
Thanks Yaro for the reply on "Web scrapping does not use any AI model."
I just do not really understand WHO scrapes the website. Is this a inbuilt function of Google Sheets, or is it you/a function of DocGPT (if yes any limits?), or takes scraping place from my IP adress? Also are the any options like residential proxies offered or recommended if the scraping is blocked (which may happen if you scrape hundreds of webpages in short time).
"I just do not really understand WHO scrapes the website. Is this a inbuilt function of Google Sheets, or is it you/a function of DocGPT (if yes any limits?)"
I have implemented all functions via native code for Add-Ons to provided the best possible performance.
So there is no custom "middle server".
This Add-On functions are executed in cloud of Google. which could use some period of time the same external ip and often changed.
To have as diff as possible, just refresh the page with spreadsheet as often as possible. ( it will rebalance your requests to diff server "pods" )
There are limitations only for amount calling functions for Google Sheets/ per account. I do not remember how much, but if you are not going to ddos someone, you should not to reach them :)
Q: 1) When scrapping the content of the webpage, does it get everything or just the main contents - I know most ...
scrappers would just get everything including useless sidebars, menu nav, etc.
2) Are you able to do a google search and get top 10 results and scrape?
Yaro_DocGPT_AI
May 15, 2024A: Hi!
1) About scraping
- There is functions for getting specific tags like h1,h2, title, description. (like WEB_H1....)
- Also there is function for getting whole content like: WEB_URL
2) About google search. i have planned this function soon, but it will use official API from Google that is paid (also needed to provide api key), their cost about 0.01$ per request.
I dont like use "black" workarounds for scraping google, they are very unstable.
Let me know if you are interested in this func, i will prioritize it in backlog
There are following functions for scraping:
WEB SCRAPPING:
=WEB_URL("https://docgpt.ai")
=WEB_TITLE("https://docgpt.ai")
=WEB_DESCRIPTION("https://docgpt.ai")
=WEB_H1("https://docgpt.ai")
=WEB_H2("https://docgpt.ai/")
=WEB_HEADINGS("https://docgpt.ai")
=WEB_PARAGRAPHS("https://docgpt.ai")
=WEB_URLS_DATA(A37:A39)
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Does it support Dutch prompts as well?
Yaro_DocGPT_AI
May 15, 2024A: Hello!
Yes it supports over 90+ languages. Dutch - included.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can you combine the AI formulas with standard sheet formulas
Yaro_DocGPT_AI
May 15, 2024A: Hello!
Yes you can use any additional formulas. Also you can use even cells, ranges, & for the AI functions.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: everytime i would refresh the sheet would it keep calling the API to load the data from GPT costing me more credits ?
Yaro_DocGPT_AI
May 15, 2024A: Hi Rekklested!
Google Sheets works this way as you mentioned. So due to that the Add-On has two buttons:
- Refresh Selected functions (it replaces selected cells with actual text)
- Refresh All functions (it replaces all add-on's functions with the actual text on the spreadsheet
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can I use this on multiple Gmail accounts or is it one per code?
Yaro_DocGPT_AI
May 15, 2024A: Hi Jake!
- 1 subscription per account
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Lol so no?
Obviously its my other emails but I work from multiple gmail google drives so I use sheets with different emails.
after working with a document, you can just share it to other accounts in 2 clicks
Q: Hello, since we have to bring our own API keys.
Without going to each site and looking costs, can you briefly describe which libraries are the cheapest? I know GPT4 is the most expensive I believe.
Yaro_DocGPT_AI
May 15, 2024A: - GPT-3 Turbo very cheap
- Gemini also cheap, but so far works only for USA accounts (or VPN to USA)
Personally me - my favorite GPT-3
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Q: Can this interact with SQL?
Yaro_DocGPT_AI
May 15, 2024A: Hi buddy!
What db do you want to use inside ?
Currently we planned in dev sprint to deliver supporting classic Relational Database that works with JDBC (Posgress, Mysql, AWS Redshift, Hive-jdbc driver)
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
Hi buddy!
What db do you want to use inside ?
Currently we planned in dev sprint to deliver supporting classic Relational Database that works with JDBC (Posgress, Mysql, AWS Redshift, Hive-jdbc driver)
Q: Do you have access to our data?
Or only the LLM we use?
Yaro_DocGPT_AI
May 15, 2024A: Hi!
- Only AI vendors has access.
- from our side we use only your email to track your accounts for auth
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
How about image generation?
Currently it has image recognition:
you can use =GPT_IMAGE(url, prompt)
but we have planned in sprint for image generation with other ai models
Q: How does this compare to Sheets Magic (doing very very well in Appsumo) and also GPT for Work.
Both are very established and well known. Both are very good as far as I know.
I'm sure many people would be asking you about this.
Also, what are our plans for your product. I don't expect it to be as good or established as the former 2, so would like to know your plans and roadmap. Thanks.
Yaro_DocGPT_AI
May 15, 2024A: Hi buddy!
- GPT, Gemini, Mistral, Claude for Google Sheets (current product) supports more AI models (Gemini, Mistral, Claude), has less price, more reviews in Workspace Store, and higher rating.
- Current product also - support WEB Scrapping functions
- Your mentioned products has worse functionality.
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets
GPT-3, GPT-4, GPT VISIONS (image recognition)
=GPT(prompt, [value])
=CLAUDE(prompt)
=GEMINI(prompt)
=MISTRAL(prompt)
=GPT_IMAGE(url, prompt)
=GPT_TAG(text, [tags])
=GPT_EXTRACT(text, to_extract)
=GPT_TRANSLATE(text, target, [source])
=GPT_SUMMARIZE(text, [format])
=GPT_FORMAT(text, source, target)
=GPT_CLASSIFY(text, categories)
=GPT_FILL(examples, inputs)
=GPT_LIST(prompt, [value])
=GPT_HLIST(prompt, [value])
=GPT_SPLIT(text, split_by)
=GPT_HSPLIT(text, split_by)
=GPT_APPLY(text, [task])
=GPT_TABLE(prompt, headers)
WEB SCRAPPING:
=WEB_URL("https://docgpt.ai")
=WEB_TITLE("https://docgpt.ai")
=WEB_DESCRIPTION("https://docgpt.ai")
=WEB_H1("https://docgpt.ai")
=WEB_H2("https://docgpt.ai/")
=WEB_HEADINGS("https://docgpt.ai")
=WEB_PARAGRAPHS("https://docgpt.ai")
=WEB_URLS_DATA(A37:A39)
Q: Hi, Do you have documentation on how to get Claude and Mistral Keys?
I couldn't find it :/
Also, do you have a function to replace frmulas with the static results to avoid recalculation?
Thanks!
Yaro_DocGPT_AI
May 15, 2024A: Hi David!
Documentation about creation api keys for Claude, Mistral, Gemini: https://docgpt.ai/docs/gpt-for-sheets/set-up-openai-api-keys
Specifically for Claude (Anthropic) and Mistral, please scroll down there will be 2 sections
Yes! There are 2 buttons for replacing formulas with text results.
- only selected cells
- whole spreadsheets
Share ChatGPT, API integrations, Programmatic SEO, Data Enrichment in Sheets