Colombia Southern University Strayer University Liberty University Purdue University Global Keiser University American Military University East Coast Polytechnic Institute
I'd like to get the founding date for each of them. Is this something I can do with SheetMagic.
- OR -
A similar prompt to:
Find who are the best contacts for Marketing and Communication or MarCom queries, announcements and partnerships for the MBA program or school of business along with the way to address them in an email (without the dear), and their raw LinkedIn URL as along with the Accreditor of the school in a comms separated list (AACSB, ACBSP, IACBE) into a text table
State University of New York College at Oneonta Department of Business/School of Liberal Arts and Business (SLAB)
For finding the founding date, you can probably do given that it's published online somewhere. Maybe try using the SONAR model from Perplexity or the openai/gpt-4o-mini-search-preview model as it will look it up online before returning the answer.
As for the second prompt, this may be a little harder. A lot of LLMs don't like returning personal contact info about people. You may need to first do an AI list of all the people and then try using Perplexity or the openai/gpt-4o-mini-search-preview again to find more info about them that is live on the web. It won't return in table format like your prompt, but you can ask for a specific thing in each horizontal cell and then run it for every row of people you have.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Could SheetMagic be used to create a work schedule for a team?
Hello I have a question for a use case: Could we use SheetMagic to crate a work schedule for the next month for a team? Is there a good chance that if I try, I will probably succeed? Here’s an example idea:
❯ We have a team of 15 midwives, and we need to plan their work so that all three shifts each day are covered. ❯ Each midwife has a workload (e.g. 50% oder 80%, while 100% are 42hrs per week) and preferences for certain shifts, and the day shifts each require between 5 and 8 midwives, while the night shift requires between 1 and 3, ideally 2.
A: I am not quite sure it would work for this type of thing to be 100% honest. Maybe just using ChatGPT would be better for something like that and ask for it in a table format and you could bring it into Google Sheets afterwards.
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
1) I have a spreadsheet of 10 thousand row. I want to change content of one column (having 10 thousand rows) and want each each cell of that column to be rewritten in easy language. Can sheetmagic do it in one go?
2) Can sheetmagic analyse content of one column (having 10 thousand rows) and identify keywords or most frequently used words?
3) If I buy tier 1 do I need to pay to ChatGPT anything. If so how much.
A: 1. Yes I believe you could do this pretty easily by testing & iterating on one cell to make sure you like the output you're getting and then running that prompt on all the rows in one go. 2. Yes 3. Yes, you have to pay for API costs and it depends what model you use. 4. No it can't, it is a Google Sheets addon, so it works in Google Sheets
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
[4][5]. Unlike some overpriced offerings in the city, the price for a thoughtfully pacedlunch is notably reasonable, with reports of a 17-course meal including appetizers, pieces, hand roll, miso soup, and dessert priced around $49 to $115 depending on the time and menu selection[1].
using openrouter will show the [source] , how to not included those[4][5]
straico api integration is great, but now the deal disappear, how straico API integration is great, but now the deal disappeared. How do I buy it on AppSumo? And suppose I use straico API, which can replace openrouter.ai, but when SheetMagic runs a search or creates a bulk of articles, do I still run openrouter.ai to run straico API at the same time, which means double-side credits will be consumed? and which API will be integrated soon?
How do I get support? Email replies take a long time. Do you have live support?
thanks
d625846d7c2245f586ea028867668479PLUSEdited Aug 7, 2025
A: Straico and OpenRouter are different providers, so you'd just choose one of them that you would use.
We only operate by email support right now but we have a lot of docs and videos on how to use the product, so the best way is to check our documentation: https://sheetmagic.ai/docs
Share
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Kinds of Data I Can Get
I have a list of colleges like
Colombia Southern University
Strayer University
Liberty University
Purdue University Global
Keiser University
American Military University
East Coast Polytechnic Institute
I'd like to get the founding date for each of them. Is this something I can do with SheetMagic.
- OR -
A similar prompt to:
Find who are the best contacts for Marketing and Communication or MarCom queries, announcements and partnerships for the MBA program or school of business along with the way to address them in an email (without the dear), and their raw LinkedIn URL as along with the Accreditor of the school in a comms separated list (AACSB, ACBSP, IACBE) into a text table
State University of New York College at Oneonta Department of Business/School of Liberal Arts and Business (SLAB)
Thanks,
Jeff
Curran35278
Aug 14, 2025A: Hello there!
For finding the founding date, you can probably do given that it's published online somewhere. Maybe try using the SONAR model from Perplexity or the openai/gpt-4o-mini-search-preview model as it will look it up online before returning the answer.
As for the second prompt, this may be a little harder. A lot of LLMs don't like returning personal contact info about people. You may need to first do an AI list of all the people and then try using Perplexity or the openai/gpt-4o-mini-search-preview again to find more info about them that is live on the web. It won't return in table format like your prompt, but you can ask for a specific thing in each horizontal cell and then run it for every row of people you have.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: Could SheetMagic be used to create a work schedule for a team?
Hello
I have a question for a use case:
Could we use SheetMagic to crate a work schedule for the next month for a team?
Is there a good chance that if I try, I will probably succeed?
Here’s an example idea:
❯ We have a team of 15 midwives, and we need to plan their work so that all three shifts each day are covered.
❯ Each midwife has a workload (e.g. 50% oder 80%, while 100% are 42hrs per week) and preferences for certain shifts, and the day shifts each require between 5 and 8 midwives, while the night shift requires between 1 and 3, ideally 2.
Thanks a lot, kind regards,
Thomas
Curran35278
Aug 12, 2025A: I am not quite sure it would work for this type of thing to be 100% honest. Maybe just using ChatGPT would be better for something like that and ask for it in a table format and you could bring it into Google Sheets afterwards.
Share SheetMagic: ChatGPT + Google Sheets Integration
Thank you very much for your answer!
Q: Query
I have few queries-
1) I have a spreadsheet of 10 thousand row. I want to change content of one column (having 10 thousand rows) and want each each cell of that column to be rewritten in easy language. Can sheetmagic do it in one go?
2) Can sheetmagic analyse content of one column (having 10 thousand rows) and identify keywords or most frequently used words?
3) If I buy tier 1 do I need to pay to ChatGPT anything. If so how much.
4) Can it also make online dashboard
Curran35278
Aug 12, 2025A: 1. Yes I believe you could do this pretty easily by testing & iterating on one cell to make sure you like the output you're getting and then running that prompt on all the rows in one go.
2. Yes
3. Yes, you have to pay for API costs and it depends what model you use.
4. No it can't, it is a Google Sheets addon, so it works in Google Sheets
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: [4][5]
[4][5]. Unlike some overpriced offerings in the city, the price for a thoughtfully pacedlunch is notably reasonable, with reports of a 17-course meal including appetizers, pieces, hand roll, miso soup, and dessert priced around $49 to $115 depending on the time and menu selection[1].
using openrouter will show the [source] , how to not included those[4][5]
Curran35278
Aug 12, 2025A: I would try just being really specific in the prompt to not include the sources or source numbers in the content like [1], [2], etc.
Share SheetMagic: ChatGPT + Google Sheets Integration
Q: straico api
straico api integration is great, but now the deal disappear, how straico API integration is great, but now the deal disappeared. How do I buy it on AppSumo? And suppose I use straico API, which can replace openrouter.ai, but when SheetMagic runs a search or creates a bulk of articles, do I still run openrouter.ai to run straico API at the same time, which means double-side credits will be consumed?
and which API will be integrated soon?
How do I get support? Email replies take a long time. Do you have live support?
thanks
Curran35278
Aug 12, 2025A: Straico and OpenRouter are different providers, so you'd just choose one of them that you would use.
We only operate by email support right now but we have a lot of docs and videos on how to use the product, so the best way is to check our documentation: https://sheetmagic.ai/docs
Share SheetMagic: ChatGPT + Google Sheets Integration