Getting Started with SheetMagic: A Guide to using Google Sheets with ChatGPT
Are you ready to take your Google Sheets game to the next level? Look no further than SheetMagic, a powerful script that allows you to
April 21, 2023
Login to your SheetMagic account.
Once you have opened SheetMagic, you’ll need to create a copy of your Google Sheet to use it within your own team. Follow these steps:
In order to use SheetMagic, you’ll need to have an OpenAI account and create a new secret key for SheetMagic. Here’s how to do it:
IMPORTANT NOTE: You may need to add a card on file to the account first before creating an API key is an option!
Now that you have an OpenAI API key, you’ll need to set it in SheetMagic. Here’s how:
Congratulations! You’re now ready to start using SheetMagic. Here’s how to use it:
=ai("your prompt here") to call ChatGPT.=ai("the beginning of your prompt,", A3, A5).This function is the core way you use AI in Google Sheets. It uses GPT-3.5 Turbo from OpenAI.
To interact with your spreadsheet, here's a basic example:
=ai("Summarize this information: ", A2)
This would summarize all the information in the cell A2.
You could also use a range of cells OR with multiple cells separated by commas. For example, you could type
=ai("Summarize this information: ", A2:A50)
or
=ai("Summarize this information: ", A2, B6)
This function is the exact same as the =ai() function, but uses GPT-4 when calling OpenAI. It is slightly more expensive, but tends to generate better outputs.
This function will visit a URL and return all of the content on that page (which you can then interact with using AI).
For example, if you type into a cell:
=visit("https://www.hubspot.com/inbound-marketing")
It would return all of the content on that page in the cell,
This can be helpful for a wide variety of reasons, but as an example, you could use AI on the content to create a better blog post. You could use AI to extract the important topics your competitors talk about in their post or use AI to determine topics that they missed so you can create something more unique.
Opportunities are endless and you could use it for a wide variety of use cases - that is just a small one.
This function will return the top 20 search results from DuckDuckGo in a table with the URL, meta title, and meta description.
For example, if you type into a cell:
=serp("Best running shoes for men")
It would return the top 20 search results for that search query:
This function will get all sorts of page data for a list of URLs and put it into an organized table for you.
For example, if you type into a cell:
=pagedata("https://www.hubspot.com/", "https://callscaler.com")
It would scrape and return the URL, Meta Title, Meta Description, H1, all the headings shown on the page, and all the paragraphs on the page each into their own cell.
You can also use other scraping functions as well for specific parts about a page:
=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.
Are you a visual learner? No problem! Here are some videos to get you started!
Written guides on how to use SheetMagic
Are you ready to take your Google Sheets game to the next level? Look no further than SheetMagic, a powerful script that allows you to
Are you looking for ways to improve your website’s SEO? Look no further than SheetMagic, a powerful tool that can help you generate content ideas,
SheetMagic is a powerful tool that can revolutionize the way you work with Google Sheets. With its AI capabilities, you can automate repetitive tasks, generate
We've recently updated this so that it outputs the exact error so that you can learn & fix the issue yourself. You may also see the message "An error occurred from OpenAIs side. This is not related to SheetMagic & the issue stems directly from your OpenAI account."
There are two typical errors in this situation...
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.
If you're still having trouble, please include a shareable link to your sheet in a support message so we can check the issue and let us know what error you're seeing.
Unfortunately Google Sheets has a hard limit of 30 seconds for each function to run, so if you try to create longer outputs it will not work because it takes too long and it will cause an error because of the Google Sheets limit.
Fix: Try breaking up your task into a few different tasks and combine them in the end to get around the maximum execution time.
Sometimes people see an error that says Error occurred while saving the API Key.
Fix: Please try clearing your cache, reloading the page, and trying again. If that still does not work, try making a new copy of the original SheetMagic document.
Backed by CV Ventures
© 2023 All rights reserved
Disclosure: SheetMagic's use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements. Visit our privacy policy for more info.