For many of the AI-powered features within Smart Spreadsheets, such as those in Smart Spreadsheets Writer, Straico AI, and Social Post Pro, you will need to connect your own API key from a third-party AI provider (e.g., OpenAI, Anthropic, or Straico).
Smart Spreadsheets facilitates the connection to these services but doesn't provide its own API credits for them.
Hello, I'm just looking for a simple use case: being able to run a prompt in a Google Sheets formula. For example =AI("My prompt"), in any Google Sheets I open. Is it possible?
A: While our suite is primarily designed for bulk automation tasks, we understand the value of having an in-cell AI prompt feature like =AI("My prompt").
Although this functionality isn't currently available, we're open to implementing it for you. Please let us know your specific requirements, and we'll be happy to assist further.
Can this tool scrape data from the listing pages of an online directory and give me specific details like listing name, description address, phone number, email, working hours etc. The data is available without any login or registration on the target site. I need your tool to AUTOMATICALLY do this from all the pages and NOT by me entering each target url manually. I see that you have integrations with ScrapingBee, Serper, or Apify and I am okay paying for their subscriptions to get this functionality.
A: Unfortunately, SmartSpreadsheets isn’t set up to crawl and paginate through directory listings automatically—we rely on explicit URLs per extraction to ensure reliability and stay compliant with our scraping API providers’ terms. For fully automated, multi‑page scraping you’d need a custom crawler (e.g., an Apify actor or similar) that handles pagination logic.
Is it possible to scrape stock data and update regularly in google sheet? For example, if the below link is in cell A2, can the name be populated in C2, price be populated in D2, etc.
A: Currently its not possible to scrape stock data. I am not sure if you are aware of this, but you can get GOOGLEFINANCE data in the sheet by using this: https://support.google.com/docs/answer/3093281?hl=en
GOOGLEFINANCE and IMPORTXML doesn't work for all stocks. Hence, checking if your software works.
Q: Mysql
HI, is it possible to synchronize google sheet with mysql database? i have a project in laravel and i would like to manage content directly in google sheets.
Q: API needed
Hello,
Is a third-party API absolutely necessary to work with Smart Spreadsheets or do you provide credits for your own API access?
Thank you :)
Sohails
May 13, 2025A: Hello,
For many of the AI-powered features within Smart Spreadsheets, such as those in Smart Spreadsheets Writer, Straico AI, and Social Post Pro, you will need to connect your own API key from a third-party AI provider (e.g., OpenAI, Anthropic, or Straico).
Smart Spreadsheets facilitates the connection to these services but doesn't provide its own API credits for them.
However, the...
Share Smart Spreadsheets
Q: AI formula in Google Sheets
Hello, I'm just looking for a simple use case: being able to run a prompt in a Google Sheets formula. For example =AI("My prompt"), in any Google Sheets I open. Is it possible?
Sohails
May 2, 2025A: While our suite is primarily designed for bulk automation tasks, we understand the value of having an in-cell AI prompt feature like =AI("My prompt").
Although this functionality isn't currently available, we're open to implementing it for you. Please let us know your specific requirements, and we'll be happy to assist further.
Share Smart Spreadsheets
Q: Scraping A Particular Website
Hi,
Thank you for coming to appsumo.
Can this tool scrape data from the listing pages of an online directory and give me specific details like listing name, description address, phone number, email, working hours etc. The data is available without any login or registration on the target site. I need your tool to AUTOMATICALLY do this from all the pages and NOT by me entering each target url manually. I see that you have integrations with ScrapingBee, Serper, or Apify and I am okay paying for their subscriptions to get this functionality.
I would really appreciate your reply on this.
Sohails
Apr 20, 2025A: Unfortunately, SmartSpreadsheets isn’t set up to crawl and paginate through directory listings automatically—we rely on explicit URLs per extraction to ensure reliability and stay compliant with our scraping API providers’ terms. For fully automated, multi‑page scraping you’d need a custom crawler (e.g., an Apify actor or similar) that handles pagination logic.
Share Smart Spreadsheets
Q: Scrape Stock Data to Google Sheets
Is it possible to scrape stock data and update regularly in google sheet? For example, if the below link is in cell A2, can the name be populated in C2, price be populated in D2, etc.
https://sg.finance.yahoo.com/quote/MBH.SI/
Sohails
Apr 19, 2025A: Currently its not possible to scrape stock data. I am not sure if you are aware of this, but you can get GOOGLEFINANCE data in the sheet by using this: https://support.google.com/docs/answer/3093281?hl=en
Let me know if you want this automated regularly.
Share Smart Spreadsheets
GOOGLEFINANCE and IMPORTXML doesn't work for all stocks. Hence, checking if your software works.
Q: Mysql
HI, is it possible to synchronize google sheet with mysql database? i have a project in laravel and i would like to manage content directly in google sheets.
Sohails
Apr 12, 2025A: No, our sheet doesn't have such feature.
Share Smart Spreadsheets