Monday.com Data Sync and Excel Automation
Budget: £250 – £750 GBP
I'm seeking an expert to automate data extraction from my Monday.com board and integrate it with a specific Excel template. The process should be triggered by a status change to 'Process Invoice' in a designated column.
Key requirements include:
- Extracting specific fields from Monday.com such as Project, Client, City, Country, Project Nr., Scope of Work, m2, Project Lead, 2nd Lead, and Status.
- Populating these fields into predetermined locations in the 'Letter Template' Excel file.
- Initiating a macro in the Excel spreadsheet post data entry.
- Updating the Monday.com entry with calculated data from Excel and altering the status after the macro execution.
Ideal candidates should have:
- Proven experience with Monday.com and Excel.
- Strong skills in automation and macro creation.
- Capacity for precise data handling and updates.
Key requirements include:
- Extracting specific fields from Monday.com such as Project, Client, City, Country, Project Nr., Scope of Work, m2, Project Lead, 2nd Lead, and Status.
- Populating these fields into predetermined locations in the 'Letter Template' Excel file.
- Initiating a macro in the Excel spreadsheet post data entry.
- Updating the Monday.com entry with calculated data from Excel and altering the status after the macro execution.
Ideal candidates should have:
- Proven experience with Monday.com and Excel.
- Strong skills in automation and macro creation.
- Capacity for precise data handling and updates.