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.
I have a list Reddit URL's in a column. Can your software loop through each one automatically, scrape all the comments on the page, and post it into a Google Sheet or Google Doc?
Here is an example link I would like to scrape: https://old.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
A: Data Scraper Pro can scrape the URLs, but it will show all comments in a raw format. If you are tech savvy you can further develop the script to get your desired output.
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
Q: Scraping Reddit
I have a list Reddit URL's in a column. Can your software loop through each one automatically, scrape all the comments on the page, and post it into a Google Sheet or Google Doc?
Here is an example link I would like to scrape: https://old.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
https://www.reddit.com/r/phoenix/comments/1ecbyo2/ac_unit_went_out_any_advice_would_be_appreciated/
Sohails
Apr 12, 2025A: Data Scraper Pro can scrape the URLs, but it will show all comments in a raw format. If you are tech savvy you can further develop the script to get your desired output.
Share Smart Spreadsheets
Can you test Reddit scraping to make sure? I have round they basically block scrapers or return a random result.
Sure, we will test and let you know.