I'm currently working on a project where I'm using crunchbase information on a spreadsheet to obtain some insights and information.
The task in particular for freelancer is to simply build a workflow (VBA / macro) that from the spreadsheet (either google sheets or excel) will:
- open crunchbase website
- Login with the credentials I have
- open a Saved query within crunchbase
- Download the results of the search to a CSV
- Import the CSV information to a specific tab of the sheet, replacing the existing information on that tab
Please note that when exporting the data from crunchbase manually, it typically limits the csv to 1000 rows. If possible, I would like to be able to download ALL the data that the query returns
Hope this is helpful.
8 фрилансеров(-а) готовы выполнить эту работу в среднем за £52
I have read your project details, will definitely assist in creating VBA / macro solution for this issue. Please get in touch for more discussions. Yassine.