We have linked our Gmail Calendar into a Monday board but we need to extract information from the Details that are imported (into a single column) and then move it into different columns, where the calendar event has information such as name phone number, address etc.
We can format the details in the event so the information we want to Extract is “isolated”
Eg;
** Name, for event **
@@ Email of Person @@
!! Phone number of Person !!
in this format what would the “function be” to Extract the data between the special character’s?
Welcome to the Community!
It’s worth having a look at ‘Extract AI’ in the app marketplace - this should help you take from the updates the things that you need and paste into relevant columns.
Thanks for reaching out to the community! The availability of pre-built integrations to perform this action is considerably low. However, by using the Extract.AI app in the monday.com marketplace, you can extract data from Gmail Calendar schedules/tasks and automatically feed it into the sheets. It saves you time and eliminates errors. It’s also easier to perform basic data analysis using this app, such as adding the hours and sorting the activities.
If you’re looking to automate the data export activities, collaborate with skilled monday.com consultants. They can close the bridge between acquiring data and using its full potential. In addition, the consultants can help you easily track Calendar details and improve metrics by setting up dashboards.
