Adding Country Codes in Google Sheets for Make.com Users

Have you ever found yourself in a situation where you have a list of phone numbers and countries in your Google Sheets, but you don't have the country codes that monday.com needs? Well, you're not alone. This is a common problem that many Make.com users face. But don't worry, we have a solution for you.

Problem

When sending phone numbers from Google Sheets to monday.com, the platform requires the country codes. However, these codes are not available in the sheets, only the country names are.

Solution

One solution is to use a lookup table in your Google Sheets to match the country name to its corresponding country code. You can then use a formula or script to automatically add the country code to the phone number before sending it to monday.com.

Another solution is to use a service like Opencage Data which provides a simple way to find the country code using the country name. You can also use a script in your Google Sheet to add the country code. This script would contain a list of countries and their corresponding country codes.

Alternatively, you can use the Phone Number module to validate the number and get the data you need for monday.com. This module is very useful but it cannot find the country code by the name of the country.

Troubleshooting Tips

If you're still having trouble, you could try using the ISO app to convert the country name to the ISO country code, and then use the returned two-character country code as the “Default country for parsing” as part of the input to the Phone Number app.

Conclusion

In conclusion, there are several ways to add country codes to your phone numbers in Google Sheets before sending them to monday.com. Whether you choose to use a lookup table, a script, or a module, the important thing is to find a solution that works best for you. Remember, the goal is to make your work easier, not harder. So, choose the method that you find most convenient and efficient.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.