SolveGPT
No-Limit AI Solutions for Your Google SheetsTM
SolveGPT offers a simple, powerful, and budget-friendly solution for integrating OpenAI's text and image generation capabilities into your Google Sheets™
Start instantly with
SolveGPT()
functionUse
SolveGPTList()
for advanced operationsUse
SolveGPTImage()
for generating imagesGenerate list of data
Generate tables
Analyze data
Extract data
Solve many more scenarios...
Use your own OpenAITM API Key
Choose your model
gpt-3.5.turbo
orgpt-4
Built in caching for cost effective operation
FREE installation
SolveGPT Benefits
✅Classify and analyze data for day to day business operations. Become super productive and finish in seconds instead of hours.
SolveGPT(B3:B15,"Categorize the reviews as Positive, Negative or Neutral")
✅Create content ideas using ChatGPT directly to your spreadsheet. No need to copy paste content from ChatGPT into spreadsheets.
SolveGPTList("Create 10 blog post ideas for a Bali travel website")
✅Generate a table of information for just about anything.
=SolveGPTList("Generate a table of 10 users with first name, last name, age and email")
✅Translate data from one language to another
SolveGPT(A1:A10, "Translate to French","gpt-4")
✅Cache data in your spreadsheet and save on OpenAPI costs for subsequent operations using a simple cackeKey
✅Extract data just with 1 prompt from a complex dataset
=SolveGPT(B2:B6,"Extract the name, address, city, state and zip code")
✅Your own data and your own API key.
✅FREE for 100 executions.
Privacy Policy
Last updated: Jul 01st, 2024This Privacy Policy describes Our policies and procedures on the collection, use, and disclosure of Your information when You use the Service and tells You about Your privacy rights and how the law protects You. SolveGPT's use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements. We use Your Personal data to provide and improve the Service. By using the Service, You agree to the collection and use of information in accordance with this Privacy Policy.Interpretation and DefinitionsInterpretation
The words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.Definitions
For the purposes of this Privacy Policy:Account means a unique account created for You to access our Service or parts of our Service.Affiliate means an entity that controls, is controlled by, or is under common control with a party, where "control" means ownership of 50% or more of the shares, equity interest or other securities entitled to vote for election of directors or other managing authority.Application means the software program provided by the Company downloaded by You on any electronic device, named SolveGPT.Country refers to Hyderabad, India.Device means any device that can access the Service such as a computer, a cellphone or a digital tablet.Personal Data is any information that relates to an identified or identifiable individual.Service refers to the Application.Service Provider means any natural or legal person who processes the data on behalf of the Company. It refers to third-party companies or individuals employed by the Company to facilitate the Service, to provide the Service on behalf of the Company, to perform services related to the Service or to assist the Company in analyzing how the Service is used.Third-party Social Media Service refers to any website or any social network website through which a User can log in or create an account to use the Service.Usage Data refers to data collected automatically, either generated by the use of the Service or from the Service infrastructure itself (for example, the duration of a page visit).You means the individual accessing or using the Service, or the company, or other legal entity on behalf of which such individual is accessing or using the Service, as applicable.
Collecting and Using Your Personal DataTypes of Data CollectedPersonal Data
While using Our Service, We may ask You to provide Us with certain personally identifiable information that can be used to contact or identify You. Personally identifiable information may include, but is not limited to:Email address
Usage DataUsage Data
Usage Data is collected automatically when using the Service. Usage Data may include information such as Your Device's Internet Protocol address (e.g. IP address), browser type, browser version, the pages of our Service that You visit, the time and date of Your visit, the time spent on those pages, unique device identifiers and other diagnostic data. When You access the Service by or through a mobile device, We may collect certain information automatically, including, but not limited to, the type of mobile device You use, Your mobile device unique ID, the IP address of Your mobile device, Your mobile operating system, the type of mobile Internet browser You use, unique device identifiers and other diagnostic data. We may also collect information that Your browser sends whenever You visit our Service or when You access the Service by or through a mobile device.Information from Third-Party Social Media Services
The Company allows You to create an account and log in to use the Service through the following Third-party Social Media Services:GoogleThe use of data obtained from such third party services is governed by Google API Services User Data PolicyIf You decide to register through or otherwise grant us access to a Third-Party Social Media Service, We may collect Personal data that is already associated with Your Third-Party Social Media Service's account, such as Your name, Your email address, Your activities, or Your contact list associated with that account. You may also have the option of sharing additional information with the Company through Your Third-Party Social Media Service's account. If You choose to provide such information and Personal Data, during registration or otherwise, You are giving the Company permission to use, share, and store it in a manner consistent with this Privacy Policy.Use of Your Personal Data
The Company may use Personal Data for the following purposes:To provide and maintain our Service, including to monitor the usage of our Service.
To manage Your Account: to manage Your registration as a user of the Service. The Personal Data You provide can give You access to different functionalities of the Service that are available to You as a registered user.
For the performance of a contract: the development, compliance and undertaking of the purchase contract for the products, items or services You have purchased or of any other contract with Us through the Service.
To contact You: To contact You by email, telephone calls, SMS, or other equivalent forms of electronic communication, such as a mobile application's push notifications regarding updates or informative communications related to the functionalities, products, or contracted services, including the security updates, when necessary or reasonable for their implementation.
To provide You with news, special offers, and general information about other goods, services, and events which we offer that are similar to those that you have already purchased or enquired about unless You have opted not to receive such information.
To manage Your requests: To attend and manage Your requests to Us.
For business transfers: We may use Your information to evaluate or conduct a merger, divestiture, restructuring, reorganization, dissolution, or other sale or transfer of some or all of Our assets, whether as a going concern or as part of bankruptcy, liquidation, or similar proceeding, in which Personal Data held by Us about our Service users is among the assets transferred.
For other purposes: We may use Your information for other purposes, such as data analysis, identifying usage trends, determining the effectiveness of our promotional campaigns and to evaluate and improve our Service, products, services, marketing, and your experience.We may share Your personal information in the following situations:With Service Providers: We may share Your personal information with Service Providers to monitor and analyze the use of our Service, to contact You.
For business transfers: We may share or transfer Your personal information in connection with, or during negotiations of, any merger, sale of Company assets, financing, or acquisition of all or a portion of Our business to another company.
With Affiliates: We may share Your information with Our affiliates, in which case we will require those affiliates to honor this Privacy Policy. Affiliates include Our parent company and any other subsidiaries, joint venture partners or other companies that We control or that are under common control with Us.
With business partners: We may share Your information with Our business partners to offer You certain products, services, or promotions.With Your consent: We may disclose your personal information for any other purpose with your consent.Retention of Your Personal Data
The Company will retain Your Personal Data only for as long as is necessary for the purposes set out in this Privacy Policy. We will retain and use Your Personal Data to the extent necessary to comply with our legal obligations (for example, if we are required to retain your data to comply with applicable laws), resolve disputes, and enforce our legal agreements and policies. The Company will also retain Usage Data for internal analysis purposes. Usage Data is generally retained for a shorter period of time, except when this data is used to strengthen the security or to improve the functionality of Our Service, or We are legally obligated to retain this data for longer time periods.Transfer of Your Personal Data
Your information, including Personal Data, is processed at the Company's operating offices and in any other places where the parties involved in the processing are located. It means that this information may be transferred to — and maintained on — computers located outside of Your state, province, country, or other governmental jurisdiction where the data protection laws may differ than those from Your jurisdiction. Your consent to this Privacy Policy followed by Your submission of such information represents Your agreement to that transfer. The Company will take all steps reasonably necessary to ensure that Your data is treated securely and in accordance with this Privacy Policy and no transfer of Your Personal Data will take place to an organization or a country unless there are adequate controls in place including the security of Your data and other personal information.Delete Your Personal Data
You have the right to delete or request that We assist in deleting the Personal Data that We have collected about You. Our Service may give You the ability to delete certain information about You from within the Service. You may update, amend, or delete Your information at any time by signing in to Your Account, if you have one, and visiting the account settings section that allows you to manage Your personal information. You may also contact Us to request access to, correct, or delete any personal information that You have provided to Us. Please note, however, that We may need to retain certain information when we have a legal obligation or lawful basis to do so.Disclosure of Your Personal Data
Large Language LLMs like ChatGPTTM
We enable the use of ChatGPTTM in Google SheetsTM via this add on. This means the data selected by you in the custom formulas from your spreadsheet will be submitted to OpenAITM via the ChatGPTTM API. This transmission happens using your own OpenAITM API key and is governed by the OpenAPI privacy policyBusiness Transactions
If the Company is involved in a merger, acquisition or asset sale, Your Personal Data may be transferred. We will provide notice before Your Personal Data is transferred and becomes subject to a different Privacy Policy.Law enforcement
Under certain circumstances, the Company may be required to disclose Your Personal Data if required to do so by law or in response to valid requests by public authorities (e.g. a court or a government agency).Other legal requirements
The Company may disclose Your Personal Data in the good faith belief that such action is necessary to:Comply with a legal obligation
Protect and defend the rights or property of the Company
Prevent or investigate possible wrongdoing in connection with the Service
Protect the personal safety of Users of the Service or the public
Protect against legal liabilitySecurity of Your Personal Data
The security of Your Personal Data is important to Us, but remember that no method of transmission over the Internet, or method of electronic storage is 100% secure. While We strive to use commercially acceptable means to protect Your Personal Data, We cannot guarantee its absolute security.Children's Privacy
Our Service does not address anyone under the age of 13. We do not knowingly collect personally identifiable information from anyone under the age of 13. If You are a parent or guardian and You are aware that Your child has provided Us with Personal Data, please contact Us. If We become aware that We have collected Personal Data from anyone under the age of 13 without verification of parental consent, We take steps to remove that information from Our servers. If We need to rely on consent as a legal basis for processing Your information and Your country requires consent from a parent, We may require Your parent's consent before We collect and use that information.Links to Other Websites
Our Service may contain links to other websites that are not operated by Us. If You click on a third-party link, You will be directed to that third party's site. We strongly advise You to review the Privacy Policy of every site You visit. We have no control over and assume no responsibility for the content, privacy policies or practices of any third-party sites or services.Changes to this Privacy Policy
We may update Our Privacy Policy from time to time. We will notify You of any changes by posting the new Privacy Policy on this page. We will let You know via email and/or a prominent notice on Our Service, prior to the change becoming effective and update the "Last updated" date at the top of this Privacy Policy. You are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.Contact Us
If you have any questions about this Privacy Policy, You can contact us:
By email: [email protected]
Terms of Service
Last updated: 01 Jul 2024This Privacy Policy describes how your personal information is collected, used, and shared when you visit or make a purchase from https://www.solvegpt.xyz (the “Site”).1. Acceptance of TermsBy accessing or using our Service, you agree to be bound by these Terms and our Privacy Policy. If you do not agree to these Terms, you may not use our Service.2. Changes to TermsWe reserve the right to modify these Terms at any time. We will notify you of any changes by posting the new Terms on this page. Your continued use of the Service after such changes constitutes your acceptance of the new Terms.
3. Use of ServiceYou agree to use the Service only for lawful purposes and in a way that does not infringe the rights of, restrict, or inhibit anyone else's use and enjoyment of the Service. Prohibited behavior includes harassing or causing distress or inconvenience to any other user, transmitting obscene or offensive content, or disrupting the normal flow of dialogue within our Service.4. Registration and AccountsTo access certain features of our Service, you may be required to create an account. You agree to provide accurate, current, and complete information during the registration process and to update such information to keep it accurate, current, and complete. You are responsible for safeguarding your password and any activities or actions under your account.5. Privacy PolicyYour use of the Service is also governed by our Privacy Policy, which covers how we collect, use, and protect your personal information.6. Intellectual PropertyThe Service and its original content, features, and functionality are and will remain our exclusive property. Our trademarks and trade dress may not be used in connection with any product or service without our prior written consent.7. User ContentYou retain ownership of any content you submit, post, or display on or through the Service. However, by submitting, posting, or displaying content, you grant us a worldwide, non-exclusive, royalty-free license to use, copy, reproduce, process, adapt, modify, publish, transmit, display, and distribute such content in any and all media or distribution methods.8. Prohibited UsesYou may not use the Service for any purpose that is unlawful or prohibited by these Terms. This includes but is not limited to:Using the Service in any manner that could damage, disable, overburden, or impair the Service.
Impersonating any person or entity or misrepresenting your affiliation with a person or entity.
Attempting to gain unauthorized access to the Service, user accounts, or computer systems or networks connected to the Service through hacking, password mining, or any other means.9. TerminationWe may terminate or suspend your access to the Service immediately, without prior notice or liability, for any reason, including without limitation if you breach these Terms. Upon termination, your right to use the Service will cease immediately.10. Disclaimer of WarrantiesThe Service is provided on an "AS IS" and "AS AVAILABLE" basis. We make no warranties, expressed or implied, regarding the Service, including but not limited to warranties of merchantability, fitness for a particular purpose, and non-infringement.11. Limitation of LiabilityTo the maximum extent permitted by applicable law, in no event shall we, our affiliates, directors, employees, or licensors be liable for any indirect, incidental, special, consequential, or punitive damages, or any loss of profits or revenues, whether incurred directly or indirectly, or any loss of data, use, goodwill, or other intangible losses, resulting from (i) your use or inability to use the Service; (ii) any unauthorized access to or use of our servers and/or any personal information stored therein; (iii) any interruption or cessation of transmission to or from the Service; (iv) any bugs, viruses, trojan horses, or the like that may be transmitted to or through our Service by any third party; (v) any errors or omissions in any content or for any loss or damage incurred as a result of your use of any content posted, emailed, transmitted, or otherwise made available through the Service; and/or (vi) the defamatory, offensive, or illegal conduct of any third party.12. Governing LawThese Terms shall be governed and construed in accordance with the laws of [TS/India], without regard to its conflict of law provisions.13. Contact UsIf you have any questions about these Terms, please contact us:By email: [email protected]
Support
Installing SolveGPT
You can easily install SolveGPT from this link in the Google Workspace Marketplace.
Authorizing SolveGPT
You must authorize the SolveGPT add on in order for it to function correctly.
Adding your ChatGPT Key
After installation, you will see a “Solve GPT” item under the Extensions menu in your Google sheet.
Click Extensions > Solve GPT > OpenAI Key
Enter the API key in the dialog box and click Submit
Once submitted, you can use the Show Key button to view the key anytime later
Using SolveGPT Formulas
Classify and analyze data for day to day business operations. Become super productive and finish in seconds instead of hours.SolveGPT(B3:B15,"Categorize the reviews as Positive, Negative or Neutral")
Create content ideas using ChatGPT directly to your spreadsheet. No need to copy paste content from ChatGPT into spreadsheets.SolveGPTList("Create 10 blog post ideas for a Bali travel website")
Generate a table of information for just about anything.=SolveGPTList("Generate a table of 10 users with first name, last name, age and email")
Translate data from one language to anotherSolveGPT(A1:A10, "Translate to French","gpt-4")
Extract data just with 1 prompt from a complex dataset=SolveGPT(B2:B6,"Extract the name, address, city, state and zip code")
Cache data in your spreadsheet and save on OpenAPI costs for subsequent operations using a simple cackeKey
=SolveGPT(B3:B13,"Categorize the reviews as Positive, Negative or Neutral","gpt-4","sentiment-101")
Generate ImageThis will generate a URL of the image=SolveGPTImage("Generate an image of a jumping Persian cat")
This will show the image generated in the cell=IMAGE(SolveGPTImage("Generate an image of a jumping Persian cat"),4,300,300)
FAQs
Do I need my own OpenAI Key to work with SolveGPT?Yes, to use SolveGPT you need to create an OpenAI Key and then add it to the SolveGPT configuration. You can get the OpenAI keys hereWhy does SolveGPT times out after 30 seconds and how to manage that?SolveGPT is available to you as a custom function inside Google Sheets. All custom functions have a time limit of 30 seconds that applies to SolveGPT as well. The maximum time is spent in calling ChatGPT API which can sometimes take longer than 30 seconds. Try to reduce the volume of the input data (typically rows) by breaking it into smaller matches or faster models like gpt-4o-mini
.Does SolveGPT consume ChapGPT API tokens every time the sheet is opened?SolveGPT provides a caching mechanism that caches your for almost 30 days. You can use this by simply providing a unique cache key as part of the SolveGPT functions. As long as you do not change this key, the data will always be loaded from Cache and your ChatGPT tokens will not be consumed in subsequent executions. Note that this does not apply to Image generation.How should I format the input data before calling SolveGPT?1. Make sure that there are no empty rows if you are feeding SolveGPT with records from a column. Empty rows can cause the response to be misaligned.
2. Avoid new line characters “
” and special characters in the input data.Which LLM model are supported by SolveGPT?SolveGPT works with the following models gpt-4o
, gpt-4o-mini
, gpt-4-turbo
, gpt-4
, and gpt-3.5-turbo
How can I reduce ChatGPT costs?Try limiting the input data.Use models that consume lessor tokens. Models like gpt-4
can consume a lot more tokens as compared to gpt-4o
. Read this OpenAPI guide for better understanding.