Jayslay
Jayslay7mo ago

Jayslay - Hi guys, am I able to upload a csv to...

Hi guys, am I able to upload a csv to the workflow and it will loop through trigger with domain names in each row and send to domain scraper which sends the data to ai node to get back structured response (requested by prompt "info1,info2" with two fields and then add those to a csv to save or download. Can anybody give a quick high level advice on how to do this the easiest way, what nodes, how to import and export csv, just super urgent and no time to lean from scratch, appreciated! Tell me also will a 1000 row CSV that gets looped though with 1k api calls to ai only be one flow execution? Any limits on duration of execution or BS rate limits or do pause nodes exist so as to reduce speed so as 'not to hit api rate limits? Thanks!
Solution:
Hi @Jayslay, For a quick start you can clone the Upload File Trigger and modify it to include the required nodes for your usecase such as loop, upload file and return public url. You can use the BuildShip database to send and store the CSV in a table format - https://docs.buildship.com/basics/buildship-tables. And in the BuildShip tables you get an option to import the data as CSV manually too. For API call Limit - There is no rate limit from Starter Plan, in free you can have 1 concurrent execution. There's no inherent limitation on execution time or rating limit within Buildship itself. However, external APIs you use (like Google Sheets API or web scraping APIs) may have rate limits that could impact the overall execution time....
Jump to solution
1 Reply
Solution
Gaurav Chadha
Gaurav Chadha7mo ago
Hi @Jayslay, For a quick start you can clone the Upload File Trigger and modify it to include the required nodes for your usecase such as loop, upload file and return public url. You can use the BuildShip database to send and store the CSV in a table format - https://docs.buildship.com/basics/buildship-tables. And in the BuildShip tables you get an option to import the data as CSV manually too. For API call Limit - There is no rate limit from Starter Plan, in free you can have 1 concurrent execution. There's no inherent limitation on execution time or rating limit within Buildship itself. However, external APIs you use (like Google Sheets API or web scraping APIs) may have rate limits that could impact the overall execution time. Execution hours: The charges are calculated on the number of execution hours of your deployed workflow. One complete run is counted as one execution. Iteration in loop won't affect the execution hours unless it is calling the entire workflow again.