We are not looking to be on AppSumo for the foreseeable future. However, please email us at info@apispreadsheets.com so we can get more details about your use case and suggest one of our current plans to you!
Your product looks very, very interesting. I want to ask if you have at least an approximate date when you will start working on the caching layer? Thank you and good luck.
Q: Does using Google Sheet affects the speed of API response?
If so, would you say uploading an Excel sheet is better because it will using your service directly?
Does using Google Sheet count against the Google Sheets API limit?
If using Google Sheet, if I update my Google Sheet does it auto update the 'database' content that was uploaded to API Spreadsheet. Meaning if we use the API, it will contain the latest update from Google Sheet?
A: Yes, that would be possible with our tool! If you have more specific questions about how to implement that, feel free to send us an email at info@apispreadsheets.com :)
Awesome! I looked at some of your trainings but I do not see an example. Do you have an example you could provide? Or an outline to point me in the right direction?
To clarify, the total number of rows or size of your database is irrelevant. If the number of rows that your SQL query for the API is within the limits, it is all good.
While we don't have any specific integrations with Blobr, we'll definitely check them out and see if we could put any possible integration with it on our roadmap. We truly appreciate your feedback, as that is the best way for us to know where to improve our products, services, and which tools are most interesting for us to integrate with. Thanks!
gz'ipped .csv from URL - ideally based on an interval. Such a feature would eliminate the overkill for several other automation steps and third parties involved. IF its on your Roadmap, whats the ETA?
A: Hi @Another1! Thanks for your question and feedback.
We appreciate your suggestion for the possibility of importing such file formats and understand that this could streamline the process a bit. We'll be sure to analyze your feedback and review it internally for possible implementation in a future update.
Additionally, if you wish to see our current roadmap, here it is: https://trello.com/b/4s8vwYDE/api-spreadsheets-roadmap
1. User uploads CSV containing a list of Unique user ids (UIDs) 2. Script checks to see if any of the UIDs exist in the Master Database (MDB) 3. Script returns the original CSV with additional data for each row found in the MDB 4. User downloads the CSV in step 3.
My 2nd use case: 1. User uploads CSV 2. Scripts adds new rows to master database
Fingers crossed (even if it will take some custom development).
Currently, neither of the 2 use cases are fully supported.
What you can do right now is to use API Spreadsheets to get the API URL of the user uploaded files, and the API URL of your Master database, and then write a script in Python to do the checking, and adding easily.
However, I do really like these suggestions and have added them to our roadmap. You can vote for them here: https://trello.com/b/4s8vwYDE/api-spreadsheets-roadmap under the title: Custom user functions through no-code such as checking, integrating etc.'
Yes, we can help with developing custom scripts through an additional fee. If you're interested in this and want to make such a request, please reach out via admin@lovespreadsheets.com and we'll be happy to help you!
Hope this information helps. ;)
Q: Hi Adhaar,
I'm interested in the API option, and to verify it matches our use case: We have a sheet with ...
names in column A and values in col B. Can we use your API to POST a name, find a match in Col A, and get the value from the corresponding col B returned?
Yes, you can do that by performing the following: POST (create) the name and then immediately after make a GET (read) request with a query to get the value from column B. So, essentially, you'll be making back to back API requests. The way to do those can be found here: https://apispreadsheets.com/docs.
A: Hi @paultaylor08! Thanks so much for the question.
Yes, this would be very well possible within this week as we update API Spreadsheets with further features. You can contact us at support@apispreadsheets.com for more information on that! ;)
Have sent email and not got any response after 4 days. The import file section doesn't seem to be mobile optimised and makes it hard to let users see the parameters when uploaded file. There doesn't seem to be much activity on the roadmap or updates, which is a bit concerning. Would you please add estimate dates for any updates as this helps us to decide on whether to make decisions on how we can use this currently
I believe that the team has already answered your email query. We apologize for any delayed response.
Additionally, we'll review the roadmap to see if there are any changes to be made there. We appreciate your suggestion and feedback!
Thank you again for your interest in API Spreadsheets and hope that you'll enjoy using our tool ;)
Q: my another question is on limit on api requests..
how api limit is calculated? for example of i did 2 queries today. one returned 10k rows ( 10k json entries) and another query returned 10 rows ( 10 json entries) then total api request is 2 only right? or its based on how many rows returned in that case it would 1010 requests.. Let me know
Q: I wanted to know about limit and saw on of your answer in below thread.
so can you confirm that limit of rows apply only on the result of api call.. so for example in tier2, my file can have more than 100,000 rows but the limit is on result of api query that it can not return more than 100k rows at one time. Can you confirm on this?
A: Hi @plugnpaid.ac1c25! Thanks for your question.
To clarify, the file cannot have more than 100,000 rows. The only instance this might be correct is that a database can have as many rows. But even then, the query used to create an API from the database still can never exceed the number of rows.
You can actually connect as many databases as you want. From these databases, you create APIs by querying the database. Each API is equivalent to a "file" and files are capped on each tier as you can see.
we've been chatting, and I have to say, your customer service is phenomenal. Keep up the good work.
One more question, please. What size can the databases be?
In Tier 4 there is a limit of 750 files, so I can have 750 databases, am I understanding correctly? But how big can these databases be? Do you limit them in size (100 megabytes, 1 gigabyte...) or e.g. on the number of tables, rows, columns? (750 000 rows as file?)
Hi @I_am_Josef! Thanks for your reply and kind words. :)
So the way databases and files work is as follows: 1. Connect your database(s). As many as you want 2. Create your API from a database(s) by providing a query such as "select * from user" 3. Now this API is treated as a "File". And all the restrictions that apply to files apply here.
So, for example, if you are on a plan that restricts rows per file to 150,000 and your query returns more rows than that, then it will give an error. And if you create more Files (database APIs) than your plan permits, you will need to upgrade. This is how we do the restriction for databases.
Hopefully this information helps!
Q: Hi Adhaar,
can you please add a tier with 1000 rows per file, 1000 files and 1M requests per day with 30 team members?
We believe that this could be a good addition to our tiers available here on AppSumo, so we appreciate your feedback and will discuss it internally! Still, we don't have any ETA or set plans for this change, so we appreciate your patience and understanding meanwhile.
Hello, +1 for raising the limits. I would like to find here the Business plan from your website. It's 500,000 rows per file 500 files 150 000 requests per day.
Q: We would like to have something like this back in Appsumo.
Share API Spreadsheets
Q: Hello, Any hope to see this LTD back in AppSumo?
I totally missed this one and it is exactly the kind of SaaS I was looking for.
Thanks
Astha_APISpreadsheets
May 14, 2024A: Hi Kylian,
We are not looking to be on AppSumo for the foreseeable future. However, please email us at info@apispreadsheets.com so we can get more details about your use case and suggest one of our current plans to you!
Thanks,
Astha
Share API Spreadsheets
Hello,
I'd also like you to go back to Appsumo. Maybe just in some flash action :-)
Thank you and best wishes for the new year.
Q: Hello, when will the caching layer be ready?
Thanks
Share API Spreadsheets
Q: Hello.
Your product looks very, very interesting.
I want to ask if you have at least an approximate date when you will start working on the caching layer?
Thank you and good luck.
JT
Share API Spreadsheets
Q: Hi..
I'm keen to know whether to re-purchase
Can you tell us what you have been working on from the feature requests and your Trello roadmap as this is important to know things are progressing
Astha_APISpreadsheets
May 14, 2024A: Hello! Thank you for reaching out.
Currently in process we are working on CNAME integration and combining spreadsheet data due to popular demand.
Here is the Trello if you want to see more details :)
https://trello.com/b/4s8vwYDE/api-spreadsheets-roadmap
Share API Spreadsheets
Q: Does using Google Sheet affects the speed of API response?
If so, would you say uploading an Excel sheet is better because it will using your service directly?
Does using Google Sheet count against the Google Sheets API limit?
If using Google Sheet, if I update my Google Sheet does it auto update the 'database' content that was uploaded to API Spreadsheet. Meaning if we use the API, it will contain the latest update from Google Sheet?
Astha_APISpreadsheets
May 14, 2024A: Hi there, thank you for these questions!
Using Google Sheets is slightly slower than an Excel Sheet so I would recommend that depending on what your use case may be.
Currently, using Google Sheet does not count against the Google Sheets API limit.
And yes, if you update your Google Sheet it does auto update it on API Spreadsheets!
Share API Spreadsheets
Q: Can I download data from the facebook ads api and host it in google sheets?
Astha_APISpreadsheets
May 14, 2024A: Yes, that would be possible with our tool! If you have more specific questions about how to implement that, feel free to send us an email at info@apispreadsheets.com :)
Share API Spreadsheets
Q: Can we use this to build data importers for our SaaS?
Similar to how FlatFile would work?
Adhaar_APISpreadsheets
May 14, 2024A: Yes, it works very similarly!
Share API Spreadsheets
Verified purchaser
Awesome! I looked at some of your trainings but I do not see an example. Do you have an example you could provide? Or an outline to point me in the right direction?
Verified purchaser
Hi you can view this tutorial here: https://apispreadsheets.com/tutorials/import-spreadsheets-on-your-apps.html
That walks you through how to create an importer on your own website
And this guide walks you through the details of the importer module: https://apispreadsheets.com/guides/spreadsheet-importer
Q: So this may come in handy for a current project I have.
We would like to have customers upload a CSV then add that data to MySQL.
Is there row limit for the upload or for the SQL Database or both?
Leo_PartnerSupport
May 14, 2024A: Hi @coachmikemonte! Thanks for your question.
To clarify, the total number of rows or size of your database is irrelevant. If the number of rows that your SQL query for the API is within the limits, it is all good.
Hopefully this information helps!
Share API Spreadsheets
Verified purchaser
That makes sense. Glad to hear it.
Can your webhooks be triggered by formulas? Like if I used a formula that was IF(Today() is less than a date in another column, Return TRUE)
Would your system be able to pick up the column changing to the TRUE value to start an automation?
Verified purchaser
Ah, not yet! I have added this to our roadmap here: https://trello.com/c/YqeU0SrP/40-monitor-data-changes
The feature is under the heading: monitor data changes and use them to trigger actions
Q: OMG, please confirm this also would allow using an external API as start point (fetch data to sheet, act on ...
sheet, get API of finished sheet (all within gSheets)
Adhaar_APISpreadsheets
May 14, 2024A: Hi,
You can accomplish this! But you would need to write your own code and host it somewhere. We do not provide scripting yet
Share API Spreadsheets
Q: Can this be used with Blobr?
Its another deal offered right here on AS.
Leo_PartnerSupport
May 14, 2024A: Hi @Summo-Greg and thanks for your question!
While we don't have any specific integrations with Blobr, we'll definitely check them out and see if we could put any possible integration with it on our roadmap. We truly appreciate your feedback, as that is the best way for us to know where to improve our products, services, and which tools are most interesting for us to integrate with. Thanks!
We hope that you enjoy using API Spreadsheets! ;)
Share API Spreadsheets
Thanks for your response. I reached out to the blobr team and they said that this tool works great with blobr. I'm sold now.
Q: Any update on PostgreSQL as a destination?
Leo_PartnerSupport
May 14, 2024A: Hi and thanks for your question!
We are currently working on adding PostgreSQL as a destination soon. Our initial ETA is for later next week.
Hopefully this information helps!
Share API Spreadsheets
Q: Hey there, I need the abillity to import .
gz'ipped .csv from URL - ideally based on an interval. Such a feature would eliminate the overkill for several other automation steps and third parties involved. IF its on your Roadmap, whats the ETA?
Leo_PartnerSupport
May 14, 2024A: Hi @Another1! Thanks for your question and feedback.
We appreciate your suggestion for the possibility of importing such file formats and understand that this could streamline the process a bit. We'll be sure to analyze your feedback and review it internally for possible implementation in a future update.
Additionally, if you wish to see our current roadmap, here it is: https://trello.com/b/4s8vwYDE/api-spreadsheets-roadmap
Hopefully this information helps!
Share API Spreadsheets
Q: Looks like just what I've been looking for!
Please let me know if this is possible.
My use case:
1. User uploads CSV containing a list of Unique user ids (UIDs)
2. Script checks to see if any of the UIDs exist in the Master Database (MDB)
3. Script returns the original CSV with additional data for each row found in the MDB
4. User downloads the CSV in step 3.
My 2nd use case:
1. User uploads CSV
2. Scripts adds new rows to master database
Fingers crossed (even if it will take some custom development).
Thanks!
M
Adhaar_APISpreadsheets
May 14, 2024A: Hi,
Currently, neither of the 2 use cases are fully supported.
What you can do right now is to use API Spreadsheets to get the API URL of the user uploaded files, and the API URL of your Master database, and then write a script in Python to do the checking, and adding easily.
However, I do really like these suggestions and have added them to our roadmap. You can vote for them here: https://trello.com/b/4s8vwYDE/api-spreadsheets-roadmap under the title: Custom user functions through no-code such as checking, integrating etc.'
Share API Spreadsheets
Verified purchaser
Adhaar, thank you for the reply!
Do you provide a custom development service to write such a script?
Please let me know and we can discuss.
Hi @MylesWalsh! Thanks for your reply!
Yes, we can help with developing custom scripts through an additional fee. If you're interested in this and want to make such a request, please reach out via admin@lovespreadsheets.com and we'll be happy to help you!
Hope this information helps. ;)
Q: Hi Adhaar, I'm interested in the API option, and to verify it matches our use case: We have a sheet with ...
names in column A and values in col B. Can we use your API to POST a name, find a match in Col A, and get the value from the corresponding col B returned?
Leo_PartnerSupport
May 14, 2024A: Hi @Steve_Dejo! Thanks for your question!
Yes, you can do that by performing the following: POST (create) the name and then immediately after make a GET (read) request with a query to get the value from column B. So, essentially, you'll be making back to back API requests. The way to do those can be found here: https://apispreadsheets.com/docs.
Hopefully this helps!
Share API Spreadsheets
Q: So far so good.
I would like to know how to customise the following
(in the file upload section...)
Upload Files for xxxxxx@xxxx.xxx
The reason is because this doesn't look great uploading to an email address, maybe it should just say upload to 'Company Name' which we can choose
Leo_PartnerSupport
May 14, 2024A: Hi @paultaylor08! Thanks so much for the question.
Yes, this would be very well possible within this week as we update API Spreadsheets with further features. You can contact us at support@apispreadsheets.com for more information on that! ;)
Hopefully this helps!
Share API Spreadsheets
Have sent email and not got any response after 4 days.
The import file section doesn't seem to be mobile optimised and makes it hard to let users see the parameters when uploaded file.
There doesn't seem to be much activity on the roadmap or updates, which is a bit concerning. Would you please add estimate dates for any updates as this helps us to decide on whether to make decisions on how we can use this currently
Hi @paultaylor08! Thanks for the reply.
I believe that the team has already answered your email query. We apologize for any delayed response.
Additionally, we'll review the roadmap to see if there are any changes to be made there. We appreciate your suggestion and feedback!
Thank you again for your interest in API Spreadsheets and hope that you'll enjoy using our tool ;)
Q: my another question is on limit on api requests..
how api limit is calculated? for example of i did 2 queries today. one returned 10k rows ( 10k json entries) and another query returned 10 rows ( 10 json entries) then total api request is 2 only right? or its based on how many rows returned in that case it would 1010 requests.. Let me know
Leo_PartnerSupport
May 14, 2024A: Hi @plugnpaid.ac1c25! Thanks for the additional question.
Yes, as you've mentioned, in the use case you have described it would only be 2 (not 1010). Hopefully this helps!
Share API Spreadsheets
Q: I wanted to know about limit and saw on of your answer in below thread.
so can you confirm that limit of rows apply only on the result of api call.. so for example in tier2, my file can have more than 100,000 rows but the limit is on result of api query that it can not return more than 100k rows at one time. Can you confirm on this?
Leo_PartnerSupport
May 14, 2024A: Hi @plugnpaid.ac1c25! Thanks for your question.
To clarify, the file cannot have more than 100,000 rows. The only instance this might be correct is that a database can have as many rows. But even then, the query used to create an API from the database still can never exceed the number of rows.
Hopefully this clarifies it!
Share API Spreadsheets
Q: Hello, how many databases can I connect?
As well as files? Or just one?
Thank you.
Josef
Leo_PartnerSupport
May 14, 2024A: Hi @I_am_Josef! Thanks for the questions!
You can actually connect as many databases as you want. From these databases, you create APIs by querying the database. Each API is equivalent to a "file" and files are capped on each tier as you can see.
Hopefully this information helps!
Share API Spreadsheets
Hey, Leo,
we've been chatting, and I have to say, your customer service is phenomenal. Keep up the good work.
One more question, please. What size can the databases be?
In Tier 4 there is a limit of 750 files, so I can have 750 databases, am I understanding correctly?
But how big can these databases be? Do you limit them in size (100 megabytes, 1 gigabyte...) or e.g. on the number of tables, rows, columns? (750 000 rows as file?)
Thank you.
Josef
Hi @I_am_Josef! Thanks for your reply and kind words. :)
So the way databases and files work is as follows:
1. Connect your database(s). As many as you want
2. Create your API from a database(s) by providing a query such as "select * from user"
3. Now this API is treated as a "File". And all the restrictions that apply to files apply here.
So, for example, if you are on a plan that restricts rows per file to 150,000 and your query returns more rows than that, then it will give an error. And if you create more Files (database APIs) than your plan permits, you will need to upgrade. This is how we do the restriction for databases.
Hopefully this information helps!
Q: Hi Adhaar, can you please add a tier with 1000 rows per file, 1000 files and 1M requests per day with 30 team members?
Thank you very much
Josef
Leo_PartnerSupport
May 14, 2024A: Hi @I_am_Josef! Thanks for your question!
We believe that this could be a good addition to our tiers available here on AppSumo, so we appreciate your feedback and will discuss it internally! Still, we don't have any ETA or set plans for this change, so we appreciate your patience and understanding meanwhile.
Thank you again for your suggestion!
Share API Spreadsheets
Hey, Leo,
thank you for your answer. If you increase the limits on the highest tier, or add one extra with those limits, I'll buy it immediately. Thank you.
Have a nice day
Josef
Hello,
+1 for raising the limits. I would like to find here the Business plan from your website. It's
500,000 rows per file
500 files
150 000 requests per day.
Thanks
Thanks for the additional suggestions!
If we make any changes here, we'll be sure to update everyone! ;)