Q: 1 user license (teammates only)==> So this means we can add "team users in T1"?
Hello, If I get T1, does that mean I am NOT allowed team mates or does your definition above mean that I can add several teammates or coworkers on the same user liscence without having to upgrade to Tier 2? Is that possible and does that mean I must share my login credentials so that we in the office all use the same login ID and Pass or email? How does that work in T1? Very interested if we can start that way. (2) We can ask AI to make unlimited images on each sheet but is that using our own credits and not yours, right? We have to bring our own credits to the table, right? TY
A: We don’t have anything built in SheetMagic but you could do this with Google Sheets apps script or with their built in triggers and it should work fine with all the SheetMagic functions
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
In the long run, Google Sheet will have their own ChatGPT integration (they already have i think but they have not touch or see you sheetmagic yet), so how sure you are that you won't be block by the powerful Alphabet (Google) company and like 95% of lifetime becomes useless, so why should we invest?
A: I highly doubt it will ever get blocked. Google is really pushing their addon marketplace and they understand that having developers actively developing in their ecosystem is really good for their business.
Their addon ecosystem is one of the big ways they have an advantage over Microsoft’s excel so I don’t think they’ll get rid of it
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
can i do this flow? 1)seller lists page(20 sellers in 1 page. many pages) 2)open seller link 1 by 1. 3)scrape items about seller infomations. 4)after scraped 20 sellers, go to next page
A: I'm not sure what your sheet looks like, what data is included, and what you want in terms of a billing report so it's hard for me to give you an exact answer but yeah most likely. I think it's going to take some finessing and thoughtful prompting in order to get what you're looking for though.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
A: Whenever AppSumo finally approves it - it's been almost 4 weeks from them and there hasn't been any movement on getting our new listing approved, so I hope they can get it figured out soon, they must be busy.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
A: Not currently, we need to do some R&D around this to see what is possible with the API, but would like to implement something like this in the future
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: I purchased your plugin, loved it initially, and now it seems like a horror story.
Before leaving a review or refund - I would like to know if you have a solution to the issues:
1. When opening the sidebar and changing the values, the plugin never saves it. It is always loading to save, and the values that I want to add do not get saved. I tried to enable the safe mode, but have not been able to do that since day 1.
2. The tool throws an error 75% of the time, even if the input is very small. Something has changed in the tool, as I see this as a way to force users to accept your upsell to GPT 4. How can I prevent this?
3. The plugin has had degraded performance in the lat 2 weeks.
4. If Open AI stops GPT 3.5 will the plugin stop working for the users who got it on tier 1 or 2?
Lastly, for a few days your plugin also disappeared from the Google add-on. Is that usual?
A: Hi, most of these were caused by a bug that was accidentally published in the last deployment, but has now been fixed.
1. Can you send us a screenshot or video of this to support@sheetmagic.ai? We cannot replicate this issue you're seeing, but would like to get the issue fixed for you. Before screenshotting or shooting vide, please right click on the sidebar, click inspect, and navigate to the console (this will help us debug it and see any errors)
2. We published a new update earlier today - our previous update was causing some slowness (which caused errors) due to a piece of code we added, but we just updated it and got rid of that so it should be back to normal now.
3. Was not 2 weeks and was actually just a bit over a day and was caused by the same issue as mentioned in #2, but has been fixed.
4. We're planning to replace GPT 3.5 Turbo with GPT 4o Mini soon, waiting on AppSumo currently though to approve this change along with some other changes to our packages.
Best, Curran
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
I will explain my use case and have a few questions on which I need to understand if SheetMagic will work for my use case. 1) Will this tool help me organize the data? For example, if I ask AI to reorder rows and/or columns to present the data differently, will it work? 2) I want to create shareable workbooks that will have either templates or calculators with protected fields and editable fields to input the data. These shareable sheets will be within my single Google workspace but I intend to share with my prospects as lead magnets. Will SheetMagic allow unlimited sharing as long as the sheet is in a single Google Workspace? Which Tier will be suitable for this use case? Tier 3 says unlimited sharing with team and clients but I want to share with prospective clients. There is one big difference though. Lead Magnets are usually used only a few times and then forgotten. I am also thinking of limiting the AI access to a certain number of days which means the prospect will be able to use the template but AI functionality will be withdrawn. 3) I want to obviously integrate my own API key, however, I want to limit the use of API key to intended use only which is data analysis. What's the best way to limit the use of API key. I assume it will be through my account with the API provider? or are there settings within SheetMagic where I can limit this? Thanks for your input Jay
2. You're not supposed to share with people who don't have a customer-relationship with you. Maybe there is a way to do what you're trying to do without sharing the SheetMagic license? Not sure
3. Ya, create keys in OpenAI and you can do all the limiting there.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
A: I am actually not sure, you may need to try this one yourself. The actual question here is "Do custom functions in Google Sheets run when a 3rd party script adds a new row?" as that will be the determining factor so I'd look into that and see if your 3rd party tool knows
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: 1 user license (teammates only)==> So this means we can add "team users in T1"?
Hello,
If I get T1, does that mean I am NOT allowed team mates or does your definition above mean that I can add several teammates or coworkers on the same user liscence without having to upgrade to Tier 2? Is that possible and does that mean I must share my login credentials so that we in the office all use the same login ID and Pass or email? How does that work in T1? Very interested if we can start that way. (2) We can ask AI to make unlimited images on each sheet but is that using our own credits and not yours, right? We have to bring our own credits to the table, right? TY
Curran35278
Sep 3, 2024A: 1 user = 1 user. It doesn’t mean you can add or share your license with other users.
And yes, you need your own API keys and will be using your own credits.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hi! How can I extract hyperlinks from a column?
Thanks
Curran35278
Sep 3, 2024A: Try something like
=ai(“this cell contains a lot of text, please return ONLY the URL back as a response. Here’s the text: “, A1)
Just tweak that and copy/paste it down for all your cells in the column
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Q: Hello – Is it possible to use time-based triggers in SheetMagic to automate scraping and data updates?
Curran35278
Sep 3, 2024A: We don’t have anything built in SheetMagic but you could do this with Google Sheets apps script or with their built in triggers and it should work fine with all the SheetMagic functions
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: How Sure this will Not Be Block by Google
In the long run, Google Sheet will have their own ChatGPT integration (they already have i think but they have not touch or see you sheetmagic yet), so how sure you are that you won't be block by the powerful Alphabet (Google) company and like 95% of lifetime becomes useless, so why should we invest?
Curran35278
Sep 1, 2024A: I highly doubt it will ever get blocked. Google is really pushing their addon marketplace and they understand that having developers actively developing in their ecosystem is really good for their business.
Their addon ecosystem is one of the big ways they have an advantage over Microsoft’s excel so I don’t think they’ll get rid of it
Share SheetMagic: ChatGPT + Google Sheets Integration
google
Q: list page
can i do this flow?
1)seller lists page(20 sellers in 1 page. many pages)
2)open seller link 1 by 1.
3)scrape items about seller infomations.
4)after scraped 20 sellers, go to next page
Curran35278
Aug 27, 2024A: It won't automatically do that, you'd need to first get all the URLs and it will get the page data from each URL.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: How do I sign up with my appsumo code?
When I go to signup there doesn't appear to be a promo code box and I am forced to subscribe to a quarterly plan before proceeding?
Curran35278
Aug 23, 2024A: https://sheetmagic.ai/ltd-registration is where you create your account and you can add your redemption code in after you create an account
Share SheetMagic: ChatGPT + Google Sheets Integration
Verified purchaser
Ah there it is. I ended up signing up for a quarter as I couldn't find another way. Can I get a refund on that?
Q: Would it be possible for SheetGPT to analyze my Google Sheet Timesheets and create accurate billing reports for invoicing clients?
Curran35278
Aug 23, 2024A: I'm not sure what your sheet looks like, what data is included, and what you want in terms of a billing report so it's hard for me to give you an exact answer but yeah most likely. I think it's going to take some finessing and thoughtful prompting in order to get what you're looking for though.
Share SheetMagic: ChatGPT + Google Sheets Integration
Thank you. It's very simple: date / client / description / hours (in decimal)
I typically select the billing range, sort by client and date, and then sum by client.
But if it can't be 100% trusted to be accurate, then it's not worth pursuing. (probabilistic vs deterministic/programmatic)
Q: I want to promote the lifetime deal in my group.
Can i get a Tier account to test and use. Here's the group: https://es1.ca
Curran35278
Aug 23, 2024A: Sure you can get one by clicking the "Buy now" button on this page and buying the product
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hi Curran Allow to use Api like straico and.
other Ai tools thanks
Curran35278
Aug 19, 2024A: Maybe eventually but we're sticking with the options available on OpenRouter for now
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: can it generate images using dalle 3?
Curran35278
Aug 19, 2024A: Yep!
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Will ChatGPT-4o mini be available in Tier 1 for 69$?
Curran35278
Aug 19, 2024A: Whenever AppSumo finally approves it - it's been almost 4 weeks from them and there hasn't been any movement on getting our new listing approved, so I hope they can get it figured out soon, they must be busy.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Can I use it without chrome extension like edge/firefox/safari?
Curran35278
Aug 15, 2024A: Yeah, it's not a Chrome extension, it's a Google Sheets addon so you just apply it to your Google account and use it on any browser
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Would this be able to scrape google maps as well and put it into csv files with all the business data per business?
Curran35278
Aug 15, 2024A: No I don't believe the scraper works with Google Maps unfortunately
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hi, have you implemented GPT-4o mini as its a lot cheaper to run?
Thanks
Curran35278
Aug 12, 2024A: Yes, you can use it on tier 3 and above currently
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Can we use custom GPTs to generate the responses instead of the general GPT?
Curran35278
Aug 12, 2024A: Not currently, we need to do some R&D around this to see what is possible with the API, but would like to implement something like this in the future
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: I purchased your plugin, loved it initially, and now it seems like a horror story.
Before leaving a review or refund - I would like to know if you have a solution to the issues:
1. When opening the sidebar and changing the values, the plugin never saves it. It is always loading to save, and the values that I want to add do not get saved. I tried to enable the safe mode, but have not been able to do that since day 1.
2. The tool throws an error 75% of the time, even if the input is very small. Something has changed in the tool, as I see this as a way to force users to accept your upsell to GPT 4. How can I prevent this?
3. The plugin has had degraded performance in the lat 2 weeks.
4. If Open AI stops GPT 3.5 will the plugin stop working for the users who got it on tier 1 or 2?
Lastly, for a few days your plugin also disappeared from the Google add-on. Is that usual?
Thanks
Curran35278
Aug 7, 2024A: Hi, most of these were caused by a bug that was accidentally published in the last deployment, but has now been fixed.
1. Can you send us a screenshot or video of this to support@sheetmagic.ai? We cannot replicate this issue you're seeing, but would like to get the issue fixed for you. Before screenshotting or shooting vide, please right click on the sidebar, click inspect, and navigate to the console (this will help us debug it and see any errors)
2. We published a new update earlier today - our previous update was causing some slowness (which caused errors) due to a piece of code we added, but we just updated it and got rid of that so it should be back to normal now.
3. Was not 2 weeks and was actually just a bit over a day and was caused by the same issue as mentioned in #2, but has been fixed.
4. We're planning to replace GPT 3.5 Turbo with GPT 4o Mini soon, waiting on AppSumo currently though to approve this change along with some other changes to our packages.
Best,
Curran
Share SheetMagic: ChatGPT + Google Sheets Integration
It's the same thing here. Also, I can't change the model even when I input my OpenAI API.
Can you confirm with tier 1 and 2 when openai upgrade (change from3.5 to 4) I will get the cahtgpt4 access too? (thankyou)
Q: Hi, just saw an email about a new feature called bulk ranker.
I was just wondering if you could tell me more about the featured of it please. Will I be bale to create seo optimized articles in WordPress?
Thanks.
Curran35278
Aug 8, 2024A: It's another product we run which is a programmatic SEO tool for WordPress - feel free to check it out here: https://bulkranker.com
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hi Curran, SheetMagic does sound like magic!
I will explain my use case and have a few questions on which I need to understand if SheetMagic will work for my use case.
1) Will this tool help me organize the data? For example, if I ask AI to reorder rows and/or columns to present the data differently, will it work?
2) I want to create shareable workbooks that will have either templates or calculators with protected fields and editable fields to input the data. These shareable sheets will be within my single Google workspace but I intend to share with my prospects as lead magnets. Will SheetMagic allow unlimited sharing as long as the sheet is in a single Google Workspace? Which Tier will be suitable for this use case? Tier 3 says unlimited sharing with team and clients but I want to share with prospective clients. There is one big difference though. Lead Magnets are usually used only a few times and then forgotten. I am also thinking of limiting the AI access to a certain number of days which means the prospect will be able to use the template but AI functionality will be withdrawn.
3) I want to obviously integrate my own API key, however, I want to limit the use of API key to intended use only which is data analysis. What's the best way to limit the use of API key. I assume it will be through my account with the API provider? or are there settings within SheetMagic where I can limit this?
Thanks for your input
Jay
Curran35278
Aug 7, 2024A: 1. No it won't reorder rows
2. You're not supposed to share with people who don't have a customer-relationship with you. Maybe there is a way to do what you're trying to do without sharing the SheetMagic license? Not sure
3. Ya, create keys in OpenAI and you can do all the limiting there.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Hi, Do you have any templates apart from the started kit?
I’d love to see your tool being used for repurposing content for marketing, social medias, blogs.
Thanks
Curran35278
Aug 7, 2024A: The getting started guide is all that we have right now!
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Can this auto-run a prompt when a new row is added?
The use case would be that a 3rd party tool would add a row to the sheet, and then the script would automatically run in the column.
Curran35278
Aug 7, 2024A: I am actually not sure, you may need to try this one yourself. The actual question here is "Do custom functions in Google Sheets run when a 3rd party script adds a new row?" as that will be the determining factor so I'd look into that and see if your 3rd party tool knows
Share SheetMagic: ChatGPT + Google Sheets Integration