Use this add-on to get modified data back to MiniCRM. You can update data manually on Google Sheets and/or do calculations with functions and scripts to automate some of the fields in your CRM system.
āđ‚āļ”āļĒ
āļ§āļąāļ™āļ—āļĩāđˆāļ­āļąāļ›āđ€āļ”āļ•āļ‚āđ‰āļ­āļĄāļđāļĨ:26 āļĄāļāļĢāļēāļ„āļĄ 2566
āđƒāļŠāđ‰āļ‡āļēāļ™āđ„āļ”āđ‰āļāļąāļš
471
āļ āļēāļžāļĢāļ§āļĄ
Use MiniCRM's Sync to Google Sheet function to get data from MiniCRM to Google Sheets.

Use this add-on to get modified data back to MiniCRM. You can update data manually on Google Sheets and/or do calculations with functions and scripts to automate some of the fields in your CRM system.

1.) You must create a Sheet named "ToMiniCRM" that contains data to be synced to MiniCRM.
2.) The first row must be field names as shown in MiniCRM (technical names, visible in customisation screen)
3.) The first column must be the Id of the card to be updated. If it's empty or 0 the script will skip the row. You can export data sheet Url from MiniCRM and use a function like this to get the ID: =IF(FromMiniCRM!B2 <> "",REGEXEXTRACT(FromMiniCRM!B2,"[^/]+$"),0)
4.) Set SystemId & API key.
5.) Use Add-ons / MiniCRM Sync / Sync to MiniCRM to upload your data. Limits apply. Google places a limit on how-many HTTP requests you can make daily based on your subscription. 

This script can only update "Project" cards in MiniCRM, not Contacts (Person or Business).
āļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
āļĢāļēāļ„āļēāđ„āļĄāđˆāļžāļĢāđ‰āļ­āļĄāđƒāļŠāđ‰āļ‡āļēāļ™
āļ™āļąāļāļžāļąāļ’āļ™āļēāļ‹āļ­āļŸāļ•āđŒāđāļ§āļĢāđŒ
āđ„āļĄāđˆāđ„āļ”āđ‰āļĢāļ°āļšāļļāļŠāļ–āļēāļ™āļ°āļœāļđāđ‰āļ„āđ‰āļē
āļ™āđ‚āļĒāļšāļēāļĒāļ„āļ§āļēāļĄāđ€āļ›āđ‡āļ™āļŠāđˆāļ§āļ™āļ•āļąāļ§
āļ‚āđ‰āļ­āļāļģāļŦāļ™āļ”āđƒāļ™āļāļēāļĢāđƒāļŦāđ‰āļšāļĢāļīāļāļēāļĢ
MiniCRM Sync āļˆāļ°āļ‚āļ­āļŠāļīāļ—āļ˜āļīāđŒāļ—āļĩāđˆāđāļŠāļ”āļ‡āļ”āđ‰āļēāļ™āļĨāđˆāļēāļ‡ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄ
MiniCRM Sync āļ•āđ‰āļ­āļ‡āļĄāļĩāļŠāļīāļ—āļ˜āļīāđŒāđ€āļ‚āđ‰āļēāļ–āļķāļ‡āļšāļąāļāļŠāļĩ Google
āļ‹āļķāđˆāļ‡āļˆāļ°āļ­āļ™āļļāļāļēāļ•āđƒāļŦāđ‰ MiniCRM Sync āļ”āļģāđ€āļ™āļīāļ™āļāļēāļĢāļ•āđˆāļ­āđ„āļ›āļ™āļĩāđ‰
āļ”āļđāļ­āļĩāđ€āļĄāļĨāļŦāļĨāļąāļāļ‚āļ­āļ‡āļšāļąāļāļŠāļĩ Google
āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§ āļ‹āļķāđˆāļ‡āļĢāļ§āļĄāļ–āļķāļ‡āļ‚āđ‰āļ­āļĄāļđāļĨāļŠāđˆāļ§āļ™āļ•āļąāļ§āđƒāļ”āđ† āļ—āļĩāđˆāļ„āļļāļ“āđ„āļ”āđ‰āđ€āļœāļĒāđāļžāļĢāđˆāļ•āđˆāļ­āļŠāļēāļ˜āļēāļĢāļ“āļ°āļ”āđ‰āļ§āļĒ
āļĢāļĩāļ§āļīāļ§
āļ āļēāļĐāļē:
āļˆāļąāļ”āđ€āļĢāļĩāļĒāļ‡āļ•āļēāļĄ:
Google āđ„āļĄāđˆāđ„āļ”āđ‰āļ•āļĢāļ§āļˆāļŠāļ­āļšāļĢāļĩāļ§āļīāļ§āļŦāļĢāļ·āļ­āļ„āļ°āđāļ™āļ™ āļ”āļđāļ‚āđ‰āļ­āļĄāļđāļĨāđ€āļžāļīāđˆāļĄāđ€āļ•āļīāļĄāđ€āļāļĩāđˆāļĒāļ§āļāļąāļšāļĢāļĩāļ§āļīāļ§
āđ„āļĄāđˆāļĄāļĩāļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™
āļ„āđ‰āļ™āļŦāļē
āļĨāđ‰āļēāļ‡āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āļ›āļīāļ”āļāļēāļĢāļ„āđ‰āļ™āļŦāļē
āđāļ­āļ› Google
āđ€āļĄāļ™āļđāļŦāļĨāļąāļ