Stuff like this would be awesome if you create a tutorial video so we can see it in action and understand much deeper how to take adavntage of SheetGpt =)
The biggest differentiator is that SheetGPT allows you to do web browsing within Google Sheets.
This allows you to input any URL and SheetGPT will return different types of content on that page, allowing you to interact with it with AI. Super beneficial as it allows you to get more recent data (OpenAI is limited to data from 2021).
This also allows you to do some interesting things with web scraping + AI and helps you get creative with some SEO tasks.
Some other functions that you can use in SheetGPT that you can't do with a product like that:
=serp("SEARCH QUERY")
This function will return the top 20 search results in a table with the URL, meta title, and meta description.
=PageData("MULTIPLE URLS")
This function will get all sorts of page data for a list of URLs and put it into an organized table for you.
=getMetaTitle("URL")
This will return the meta title for a given URL
=getMetaDescription("URL")
This will return the meta description for a given URL
=getH1("URL")
This will return the H1 for a given URL.
=getH2("URL")
This will return any H2s on a page for a given URL.
=getHeadings("URL")
This will return all the headings on a page for a given URL.
=getp("URL")
This will return all paragraphs wrapped in a <p> tag for a given URL.
Hope that helps!
Best,
Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Here's a tutorial showing the majority of these features: https://sheetgpt.io/docs/#demo
Best, Curran
Q: Does the scraper function require us to copy and paste the actual web address into the function?
If so, why? That means manual labour for every single cell. Why can't it just refer to another cell, say, B2, where the URL is written?
Because most of us will have long lists of URLs, and we just want to copy down the formula to the whole column, thereby eliminating a massive amount of labour.
It's like that with every function too where if you're referencing a cell, you don't put it in quotes, but if you're putting the data in manually, you put it in quotes.
Hope that clarifies that :)
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Just another point on this one. I've managed to hack my way through with CONCAT formula, but despite being able to copy and paste the right scraping formula all down the column now, it doesn't set it off in every cell. It appears that it is necessary to go in and set off every one individually still.
A: Not currently because LinkedIn requires you to be logged in to see anything of value.
We'll try to see if there is a way to get around it but that one will definitely be tricky and LinkedIn definitely doesn't want people scraping their data so they'll make it difficult
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
A: Yes, you could ask the AI to create a formula for a specific task.
As for connecting a column from one sheet to another, I am not sure. I'd probably bring the data in from that other sheet into a new tab on the same sheet so it's all within one Sheet to avoid any issues
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
A: Once you redeem your codes within your account (or if you buy the LTD on our site) it will show you your license and how many people you are licensed to share it with. You will technically be the owner of that account if you redeem the codes and then you can share the Sheet with your allotted amount of people that your license states.
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
When I use "AI" I get "Error: Unable to get a response from AI. Response: {"error":{"message":"You exceeded your current quota, please check your plan and billing details.","type":"insufficient_quota","param":null,"code":"insufficient_quota"}} " When I use "GPT4" I get Error: Unable to get a response from AI. Response: {"error":{"message":"The model `gpt-4` does not exist or you do not have access to it. Learn more: https://help.openai.com/en/articles/7102672-how-can-i-access-gpt-4.","type":"invalid_request_error","param":null,"code":"model_not_found"}} I have updated my keys. I went ahead and followed the tutorial.
Here's some info from our docs about fixing these errors...
Error #1: The model `gpt-4` does not exist or you do not have access to it
Fix: As of August 4, 2023, you fix this by going to your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it's not working, check the OpenAI help article on how to get GPT-4 access as this may be more up to date as they make changes.
Error #2: You exceeded your current quota, please check your plan and billing details
Fix: To fix this, go your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it's still not working, make sure you don't have any quota settings as that may make you hit your limit.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hey Curran, you posted the response below to a question;
1.
Yes you can use the AI with ranges.
2. You can also do this along with the auto completing
3. Never used that product, but it does seem like we have more scraping capabilities especially with the upcoming release of SheetGPT v1.3
Some of the cool new scraping functions coming this week in v1.3:
=getMetaTitle()
=getMetaDescription()
=getH1()
=getH2()
=getHeadings()
=pagedata(Multiple URLs) (this will get all the data above, along with the entire page data and automatically put it into a table so you can easily get all the data organized from a list of URLs)
=serp() (grabs the top 20 search results for a given query and outputs into a table with the URL, Meta title, and Meta description)
ALL of these functions are able to be used in an unlimited fashion in ANY of the tiers you buy SheetGPT. Almost no other software allows for unlimited usage like this.
None of the new functions mentioned above will use any AI credits from OpenAI either so it comes at zero additional cost to you.
Best,
Curran
-----------------------------------------------
I asked a question which was overlooked regarding your above response, see below
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand.
Q: Since I'm reading you use duck duck go instead of the major search engines, can I use your URL= function and ...
simply have it crawl a Google search results page and tell it to grab say all the page titles or whatever for the top 10 results and then apply other processing to it once in the sheets?
Got it. This must be why other software users Google's API. It's useless to the duck duck go data if they're not the search giant we and our clients wish to rank in. Thanks for the reply. Good to know, I'm just not sure this will help anyone doing meaningful SEO wanting to streamline research. It's unfortunate but I know you've got no control over how Google reacts. Thanks again. Otherwise this seems like a useful tool.
Q: Hi,
This question is specific to Tier 3 where it says "GPT 4 Access" ?
What does it exactly mean. We are already using our own API key on all tiers. Does it mean we get to use your built-in GPT 4 key. Would really appreciate your clarification.
A: 1. Yes you can use the AI with ranges. 2. You can also do this along with the auto completing 3. Never used that product, but it does seem like we have more scraping capabilities especially with the upcoming release of SheetGPT v1.3
Some of the cool new scraping functions coming this week in v1.3: =getMetaTitle() =getMetaDescription() =getH1() =getH2() =getHeadings() =pagedata(Multiple URLs) (this will get all the data above, along with the entire page data and automatically put it into a table so you can easily get all the data organized from a list of URLs) =serp() (grabs the top 20 search results for a given query and outputs into a table with the URL, Meta title, and Meta description)
ALL of these functions are able to be used in an unlimited fashion in ANY of the tiers you buy SheetGPT. Almost no other software allows for unlimited usage like this.
None of the new functions mentioned above will use any AI credits from OpenAI either so it comes at zero additional cost to you.
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand. Thank you
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand. Thank you
Q: Hi,
In this video > https://www.
youtube.com/watch?v=-e5PBsHu6iw
You mentioned using the Serp functionality the data is being extracted from DuckDuckGo and not Google or Bing, can you explain the reason for this?
In the future will it be optional to select a specific/desired search engine based on the users needs (just a question)?
A: It's mainly because it's way harder to get around the prevention methods that Bing and Google put in place to stop people from remotely accessing their search engines. Especially since we're working within a Google Sheet.
DuckDuckGo makes it a bit easier to see the top results without getting blocked so we used that because it was the only one we could get to work reliably.
Hope that explains that :)
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
The biggest differentiator right now is that SheetGPT allows you to do web browsing within Google Sheets.
This allows you to input any URL and SheetGPT will return with all of the content on the page, allowing you to interact with it with AI. Super beneficial as it allows you to get more recent data (OpenAI is limited to data from 2021).
Also allows you to do some interesting things with web scraping + AI and helps you get creative with some SEO tasks.
Some other functions that you can use in SheetGPT that you can't do with a product like that:
=serp("SEARCH QUERY") This function will return the top 20 search results in a table with the URL, meta title, and meta description.
=PageData("MULTIPLE URLS") This function will get all sorts of page data for a list of URLs and put it into an organized table for you.
=getMetaTitle("URL") This will return the meta title for a given URL
=getMetaDescription("URL") This will return the meta description for a given URL
=getH1("URL") This will return the H1 for a given URL.
=getH2("URL") This will return any H2s on a page for a given URL.
=getHeadings("URL") This will return all the headings on a page for a given URL.
=getp("URL") This will return all paragraphs wrapped in a <p> tag for a given URL.
Hope that helps!
Best,
Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
My question is: If I was to have a Google Sheet that has a list of some related and unrelated keywords, would I be able to have this software group or sort the keywords by topical relevance?
That one could be more difficult but yeah, you may be able to if you came up with some sort of prompt did that for you.
Maybe a prompt that is something along the lines of:
=ai("I am using this for SEO. Please return the parent topic for this long-tail keyword: ", A2)
...or some sort of version of that. May take some more testing and tweaking of the prompt. I'm not sure how reliable that will be to the actual keyword cluster that Google uses but it may help at least get you in the right direction!
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: can i use this to generate articles Can use this to extract seo data from blogs
Curran35278
May 14, 2024A: Yes, you can do both of those things with SheetGPT!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Stuff like this would be awesome if you create a tutorial video so we can see it in action and understand much deeper how to take adavntage of SheetGpt =)
@AlejandroRico206
Here's a tutorial showing a few ideas to get you started: https://sheetgpt.io/docs/#demo
Best,
Curran
Q: hello, How's this tool different from GPT for Sheets and Docs that we can access for free on Google sheets ...
apart from the free usage on your app?
I want to purchase this but I need to know what makes yours more unique?
Curran35278
May 14, 2024A: Hey there.
The biggest differentiator is that SheetGPT allows you to do web browsing within Google Sheets.
This allows you to input any URL and SheetGPT will return different types of content on that page, allowing you to interact with it with AI. Super beneficial as it allows you to get more recent data (OpenAI is limited to data from 2021).
This also allows you to do some interesting things with web scraping + AI and helps you get creative with some SEO tasks.
Some other functions that you can use in SheetGPT that you can't do with a product like that:
=serp("SEARCH QUERY")
This function will return the top 20 search results in a table with the URL, meta title, and meta description.
=PageData("MULTIPLE URLS")
This function will get all sorts of page data for a list of URLs and put it into an organized table for you.
=getMetaTitle("URL")
This will return the meta title for a given URL
=getMetaDescription("URL")
This will return the meta description for a given URL
=getH1("URL")
This will return the H1 for a given URL.
=getH2("URL")
This will return any H2s on a page for a given URL.
=getHeadings("URL")
This will return all the headings on a page for a given URL.
=getp("URL")
This will return all paragraphs wrapped in a <p> tag for a given URL.
Hope that helps!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Yeah, we need tutorials based on the answer you just gave. I'll be looking forward to them!
@AlejandroRico206
Here's a tutorial showing the majority of these features: https://sheetgpt.io/docs/#demo
Best,
Curran
Q: Does the scraper function require us to copy and paste the actual web address into the function?
If so, why? That means manual labour for every single cell. Why can't it just refer to another cell, say, B2, where the URL is written?
Because most of us will have long lists of URLs, and we just want to copy down the formula to the whole column, thereby eliminating a massive amount of labour.
Or am I getting something wrong here?
Curran35278
May 14, 2024A: The scraper function can work either manually or automatically.
Manual: =visit("https://hubspot.com")
Auto: =visit(A2)
It's like that with every function too where if you're referencing a cell, you don't put it in quotes, but if you're putting the data in manually, you put it in quotes.
Hope that clarifies that :)
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Just another point on this one. I've managed to hack my way through with CONCAT formula, but despite being able to copy and paste the right scraping formula all down the column now, it doesn't set it off in every cell. It appears that it is necessary to go in and set off every one individually still.
Wow, that's working now, and it's AWESOME! Thanks!
Q: If I put a LinkedIn URL, Can It browse or scrape that?
Say 100/day?
Curran35278
May 15, 2024A: Not currently because LinkedIn requires you to be logged in to see anything of value.
We'll try to see if there is a way to get around it but that one will definitely be tricky and LinkedIn definitely doesn't want people scraping their data so they'll make it difficult
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Able to write and save formula?
To connect Column from one sheet to show total on one cell in another ?
Curran35278
May 15, 2024A: Yes, you could ask the AI to create a formula for a specific task.
As for connecting a column from one sheet to another, I am not sure. I'd probably bring the data in from that other sheet into a new tab on the same sheet so it's all within one Sheet to avoid any issues
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Is each license attached to it's own account?
e.g. one license added to a gmail account and another to a yahoo.com etc...
Curran35278
May 15, 2024A: Once you redeem your codes within your account (or if you buy the LTD on our site) it will show you your license and how many people you are licensed to share it with. You will technically be the owner of that account if you redeem the codes and then you can share the Sheet with your allotted amount of people that your license states.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Any plans of integration with Microsoft Excel?
Curran35278
May 15, 2024A: Not currently - we're focusing on making it really good for Google Sheets currently since it's free for anyone to use.
Maybe in the future though!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Can I use SheetGPT on Google Sheets AND Excel?
Or does it work only in Google Sheets?
Curran35278
May 15, 2024A: Only works with Sheets!
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Bought this 2 days ago but unable to add OpenAI Api Key as Google has blocked the tool.
Getting this error:
This app is blocked
This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.
Appreciate your help here.
Curran35278
May 15, 2024A: Weird. Does it give you a way to bypass it?
If not, maybe try doing it from a different Google account and see if that fixes the issue!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Got tier 3.
When I use "AI" I get "Error: Unable to get a response from AI. Response: {"error":{"message":"You exceeded your current quota, please check your plan and billing details.","type":"insufficient_quota","param":null,"code":"insufficient_quota"}} "
When I use "GPT4" I get Error: Unable to get a response from AI. Response: {"error":{"message":"The model `gpt-4` does not exist or you do not have access to it. Learn more: https://help.openai.com/en/articles/7102672-how-can-i-access-gpt-4.","type":"invalid_request_error","param":null,"code":"model_not_found"}}
I have updated my keys. I went ahead and followed the tutorial.
Curran35278
May 15, 2024A: Hey there!
Here's some info from our docs about fixing these errors...
Error #1: The model `gpt-4` does not exist or you do not have access to it
Fix: As of August 4, 2023, you fix this by going to your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it's not working, check the OpenAI help article on how to get GPT-4 access as this may be more up to date as they make changes.
Error #2: You exceeded your current quota, please check your plan and billing details
Fix: To fix this, go your OpenAI billing settings and make sure you have a paid OpenAI account and paid at least $1 to OpenAI. If it's still not working, make sure you don't have any quota settings as that may make you hit your limit.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hey Curran, you posted the response below to a question; 1.
Yes you can use the AI with ranges.
2. You can also do this along with the auto completing
3. Never used that product, but it does seem like we have more scraping capabilities especially with the upcoming release of SheetGPT v1.3
Some of the cool new scraping functions coming this week in v1.3:
=getMetaTitle()
=getMetaDescription()
=getH1()
=getH2()
=getHeadings()
=pagedata(Multiple URLs) (this will get all the data above, along with the entire page data and automatically put it into a table so you can easily get all the data organized from a list of URLs)
=serp() (grabs the top 20 search results for a given query and outputs into a table with the URL, Meta title, and Meta description)
ALL of these functions are able to be used in an unlimited fashion in ANY of the tiers you buy SheetGPT. Almost no other software allows for unlimited usage like this.
None of the new functions mentioned above will use any AI credits from OpenAI either so it comes at zero additional cost to you.
Best,
Curran
-----------------------------------------------
I asked a question which was overlooked regarding your above response, see below
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand.
Thank you
Curran35278
May 14, 2024A: Hi! Apologies on the confusion. None of the new scraping functions charge anything to your OpenAI account.
Only the =ai() and the =gpt4() functions use your OpenAI API key and will charge your OpenAI account.
Hope that clarifies that :)
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Verified purchaser
Yep, thanks for clarifying!
Q: Since I'm reading you use duck duck go instead of the major search engines, can I use your URL= function and ...
simply have it crawl a Google search results page and tell it to grab say all the page titles or whatever for the top 10 results and then apply other processing to it once in the sheets?
Curran35278
May 14, 2024A: You could try, but it may only work once or twice before you get blocked by them.
Unfortunately Google blocks a lot of attempts at remote access and do not make it easy to get around (thus the reason we scrape DuckDuckGo instead)
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Got it. This must be why other software users Google's API. It's useless to the duck duck go data if they're not the search giant we and our clients wish to rank in. Thanks for the reply. Good to know, I'm just not sure this will help anyone doing meaningful SEO wanting to streamline research. It's unfortunate but I know you've got no control over how Google reacts. Thanks again. Otherwise this seems like a useful tool.
Q: Hi, This question is specific to Tier 3 where it says "GPT 4 Access" ?
What does it exactly mean. We are already using our own API key on all tiers. Does it mean we get to use your built-in GPT 4 key. Would really appreciate your clarification.
Curran35278
May 15, 2024A: No, you need to attach your own OpenAI key no matter what tier you are on.
On the first two tiers you can use the =ai() function which calls GPT 3.5 Turbo.
On tier 3 and 4, it opens up to allow you to also use the =gpt4() function with your own OpenAI key.
On all tiers, the scraping functions are available.
Hope that clarifies that!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Do i need to attach your own OpenAI API key for unlimited usage at Tier 3 ?
Does the app have own connection to ChatGPT4 at T3?
Curran35278
May 15, 2024A: You need to attach your own OpenAI key no matter what tier you are on.
An OpenAI key is required no matter what.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: On tier 2-4, can we use different API keys?
This is to control their usage.
Curran35278
May 15, 2024A: Yes, you can set a different API key on every new sheet or replace API keys on a sheet if you share it.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: This is just what I was looking for!
I am all set. Just one question: How will I know when you update the sheet?
Thanks, Ben
Curran35278
May 15, 2024A: We will send out email updates when new updates are available!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: 1.
Can I analyze ranges of rows? Like ex. B2:B100 ?
2. Can I include multiple data? Like ex. B2, C4? (and does it autocoplete when I expand it like normal formula?)
3. How it compares to this: https://appsumo.com/products/power-formulas/
Curran35278
May 14, 2024A: 1. Yes you can use the AI with ranges.
2. You can also do this along with the auto completing
3. Never used that product, but it does seem like we have more scraping capabilities especially with the upcoming release of SheetGPT v1.3
Some of the cool new scraping functions coming this week in v1.3:
=getMetaTitle()
=getMetaDescription()
=getH1()
=getH2()
=getHeadings()
=pagedata(Multiple URLs) (this will get all the data above, along with the entire page data and automatically put it into a table so you can easily get all the data organized from a list of URLs)
=serp() (grabs the top 20 search results for a given query and outputs into a table with the URL, Meta title, and Meta description)
ALL of these functions are able to be used in an unlimited fashion in ANY of the tiers you buy SheetGPT. Almost no other software allows for unlimited usage like this.
None of the new functions mentioned above will use any AI credits from OpenAI either so it comes at zero additional cost to you.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Verified purchaser
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand. Thank you
Verified purchaser
Again, since this got no reply the first time...
Our API is connected but not charged? I'm a bit confused. @ the 3:50 mark of this video > https://www.youtube.com/watch?v=-e5PBsHu6iw, you mention utilizing an optimal AI budget. So, just a bit of clarification needed. You mentioned here non of the functions above will be of charge to users. How are we charged, what are charged for, and are we not charge certain queries, please help me understand. Thank you
Q: Hi, In this video > https://www.
youtube.com/watch?v=-e5PBsHu6iw
You mentioned using the Serp functionality the data is being extracted from DuckDuckGo and not Google or Bing, can you explain the reason for this?
In the future will it be optional to select a specific/desired search engine based on the users needs (just a question)?
Curran35278
May 14, 2024A: It's mainly because it's way harder to get around the prevention methods that Bing and Google put in place to stop people from remotely accessing their search engines. Especially since we're working within a Google Sheet.
DuckDuckGo makes it a bit easier to see the top results without getting blocked so we used that because it was the only one we could get to work reliably.
Hope that explains that :)
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Verified purchaser
Thanks, it does
Q: What's the pros/advanced features by the LTD compared to this free tool?
Thanks.
https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Curran35278
May 15, 2024A: Hey there.
The biggest differentiator right now is that SheetGPT allows you to do web browsing within Google Sheets.
This allows you to input any URL and SheetGPT will return with all of the content on the page, allowing you to interact with it with AI. Super beneficial as it allows you to get more recent data (OpenAI is limited to data from 2021).
Also allows you to do some interesting things with web scraping + AI and helps you get creative with some SEO tasks.
Some other functions that you can use in SheetGPT that you can't do with a product like that:
=serp("SEARCH QUERY")
This function will return the top 20 search results in a table with the URL, meta title, and meta description.
=PageData("MULTIPLE URLS")
This function will get all sorts of page data for a list of URLs and put it into an organized table for you.
=getMetaTitle("URL")
This will return the meta title for a given URL
=getMetaDescription("URL")
This will return the meta description for a given URL
=getH1("URL")
This will return the H1 for a given URL.
=getH2("URL")
This will return any H2s on a page for a given URL.
=getHeadings("URL")
This will return all the headings on a page for a given URL.
=getp("URL")
This will return all paragraphs wrapped in a <p> tag for a given URL.
Hope that helps!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Asking this myself
i was about to ask the same question, seems =
Q: I am VERY interested in this product!
My question is: If I was to have a Google Sheet that has a list of some related and unrelated keywords, would I be able to have this software group or sort the keywords by topical relevance?
Curran35278
May 15, 2024A: Great to hear! :)
That one could be more difficult but yeah, you may be able to if you came up with some sort of prompt did that for you.
Maybe a prompt that is something along the lines of:
=ai("I am using this for SEO. Please return the parent topic for this long-tail keyword: ", A2)
...or some sort of version of that. May take some more testing and tweaking of the prompt. I'm not sure how reliable that will be to the actual keyword cluster that Google uses but it may help at least get you in the right direction!
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration