âïž Gmail ã Google Sheets ããã¡ãŒã«ãã£ã³ããŒã³ãéä¿¡ããŸããâïž Microsoft ExcelãCSVãã¡ã€ã«ã®åä¿¡è
ã«ã察å¿ããŠããŸãã âïž Gmailã§çŽæ¥ã¡ãŒã«ããã¶ã€ã³ãGoogleããã¥ã¡ã³ãã䜿çšããŠçŸãããã¥ãŒã¹ã¬ã¿ãŒãæžãããšãã§ããŸãã âïž åä¿¡è
ãã¡ãŒã«ãéãããã©ãããã¯ãªãã¯ãããã©ããã確èªã§ããŸãã âïž è¿ä¿¡ãåŸ
ã£ãŠããŸããïŒMergoã¯èªåçã«ãã©ããŒã¢ããã¡ãŒã«ãéä¿¡ããŸã...
ð äŸ¡æ Œãæ°éãæ©èœããµããŒãã«ã€ããŠãã£ãšèªã,...
ð ãµããŒããå¿
èŠã§ãã?
ãåãåããã¯support@mergo.app ã«ãŠåœããŒã ããããã«ã察å¿ããŸãïŒ
ãããã¯ãã«ãã»ã³ã¿ãŒãã芧ãã ãã: https://help.mergo.app/
ââââââââââââââââââââââââââââââââ
â MERGOãšã¯ïŒ
Gmailâ¢ã§ã¯ãç°ãªãåä¿¡è
ã«äœçŸéãã®ã¡ãŒã«ãæåã§éä¿¡ããããšãã§ããŸãã
åããããªã¡ãŒã«ãå€ãã®åä¿¡è
ã«éãå¿
èŠãããå ŽåãMergoã¯ãã®ã¿ã¹ã¯ãèªååããããšãã§ããŸãã
Gmailâ¢ã®äžæžãã«ãã€ãã®ããã«ã¡ãã»ãŒãžãæžããåä¿¡è
ã®ãªã¹ããæå®ãããšãMergoããã®ãã¹ãŠã®åä¿¡è
ã«ã¡ãã»ãŒãžãéä¿¡ããŸãã
ââââââââââââââââââââââââââââââââ
ð° æ°éãšäŸ¡æ Œ:
†ããªãŒãã¢ã ïŒæåã®ãã£ã³ããŒã³ã¯100ïŒ
ç¡æããã®åŸ30ã¡ãŒã«/ãã£ã³ããŒã³ãŸã§ç¡æã
†ãã©ã³ã¯1.5ãã«/æããã
†æé¡ãã©ã³ã幎éãã©ã³ãçæ¶¯ãã©ã³ããããŸãã
†Google Workspaceã®ãã¡ã€ã³ã§å©çšã§ããããŒã ãã©ã³ã
https://pricing.mergo.app/
ââââââââââââââââââââââââââââââââ
ð Google sheet + Gmail⢠+ Google docsã§å©çšå¯èœã§ã
†ããŒãœãã©ã€ãºãããã¡ãŒã«ãéä¿¡ãããå Žåã¯ãGoogle Sheetsã®Mergoã䜿çšããŸãïŒã¡ãŒã«ããŒãžïŒ
†åã«åãã¡ãŒã«ãè€æ°äººã«åå¥ã«éä¿¡ããŠè¿œè·¡ãããå Žåã¯ãGmailâ¢ã§Mergoãéãã ãã§ãïŒã¡ãŒã«ãã£ã³ããŒã³ïŒ
†匷åãªããã¹ããšãã£ã¿ãŒã§ã¡ãŒã«ã®ãã³ãã¬ãŒããæžãããå Žåã¯ãGoogle Docsã®Mergoã䜿çšããŸãïŒãã¥ãŒã¹ã¬ã¿ãŒïŒ
ââââââââââââââââââââââââââââââââ
ð¯ 3ã¹ããããã¥ãŒããªã¢ã«:
1ïžâ£ Gmailâ¢ã§æ°ãããã©ãããäœæãããªãã·ã§ã³ã§{{First Name}}ãªã©ã®ããŒãžãã£ãŒã«ãã远å ããŠã¡ãŒã«ãããŒãœãã©ã€ãºããããšãã§ããŸã
2ïžâ£ Mergoãéããåä¿¡è
ãªã¹ããéžæããŸãïŒGoogleã·ãŒããCSVãExcelãGoogleã³ã³ã¿ã¯ããã³ããŒããŒã¹ãããçã®ãªã¹ãããªã©ïŒ
3ïžâ£ éä¿¡ãã¯ãªãã¯ããŸããMergoã¯èªåçã«ååä¿¡è
ã«ã¡ãã»ãŒãžãéä¿¡ããã¡ãŒã«ãã£ã³ããŒã³ã远跡ããŸãïŒéå°ãã¯ãªãã¯ãããŠã³ã¹ãè¿ä¿¡ãé
ä¿¡åæ¢ïŒ
ââââââââââââââââââââââââââââââââ
ðµïž æ©èœ
https://www.mergo.app/features
â€æ°çŸäººã®åä¿¡è
ã«ç¬æã«ã¡ãŒã«ãäžæ¬éä¿¡ã§ããŸã
†Gmail⢠ã®ãã³ãã¬ãŒããä»¶åã« {{First Name}} ãªã©ã®ããŒãžãã£ãŒã«ãã䜿çšããŠã¡ãŒã«ãããŒãœãã©ã€ãºããGoogle Sheets ã«åããããŒãšããŠãFirst Nameãã远å ããŠãã ãããMergoã¯ããã®åããèªåçã«ååãååŸããéä¿¡ãããã¡ãŒã«ã«äžè¡ãã€ããŒãžããŸã
†èªåå®ã«ãã¹ãã¡ãŒã«ãéä¿¡ãããã¬ãã¥ãŒã§ããããã«ããŸããã¡ãŒã«ã®ãã©ãŒãããããªã³ã¯ãç»åãªã©ããã§ãã¯ããåä¿¡è
ãªã¹ãã«éä¿¡ããåã«å®ç§ãªç¶æ
ã«ä»äžããããšãã§ããŸã
†Googleã³ã³ã¿ã¯ãããé£çµ¡å
ãèªåã§ã€ã³ããŒãããã€ã³ããŒãããã°ã«ãŒããéžæã§ããŸã
†ãã¹ãŠã®ã¡ãŒã«ã®éå°ãã¯ãªãã¯ãåå¿ãããŠã³ã¹ãé
ä¿¡åæ¢ãGoogle SheetsããçŽæ¥ãªã¢ã«ã¿ã€ã ã§è¿œè·¡ã§ããã®ã§ã次ã«äœãéãã°ããã®ãããããã顧客ãšã³ã²ãŒãžã¡ã³ããé«ããããšãã§ããŸã
†ã¡ãŒã«ã«é
ä¿¡åæ¢ãªã³ã¯ã远å ããããšã§ãããŒã¿ããŒã¹ãåžžã«ææ°ã®ç¶æ
ã«ä¿ã¡ãGDPRã«æºæ ããããšãã§ããŸã
†åã¡ãŒã«ã«CCããã³/ãŸãã¯BCCåä¿¡è
ã远å
†件åãæ¬æã«çµµæåãå
¥ãããšããã广çãªã¢ã€ãã£ãã广ãåŸãããŸã
†ããŒãœãã©ã€ãºãããæ·»ä»ãã¡ã€ã«ãæã€ã¡ãŒã«ããŒãžãååä¿¡è
ã«éä¿¡ããŸã
†Gmailâ¢ã§ããããããšã€ãªã¢ã¹ãšããŠèšå®ãããå¥ã®ã¡ãŒã«ã¢ãã¬ã¹ããã¡ãŒã«ãéä¿¡ããŸã
†è¿ä¿¡ãèŠéããªãããã«ãå¥ã®è¿ä¿¡å
ãæå®ããŸã
†Google DocsãGmailâ¢ã®äžæžãã«ããŸã
†Gmailâ¢ãGoogle SheetsãGoogle Docsãããã£ã³ããŒã³ãéä¿¡ããçµæãã©ãã§ã確èªã§ããŸã
†ã¡ãŒã«ããŒãžãç¹å®ã®æ¥æã«ã¹ã±ãžã¥ãŒã«ããŠãé©åãªã¿ã€ãã³ã°ã§ã¿ãŒã²ãããçµã£ãã¡ãŒã«ãéä¿¡ã§ããŸã
†Zapierãšã®é£æºãªã©ã§ãSheetsã«æ°ããè¡ã远å ããããšãã«ã¡ãŒã«ãéä¿¡ããŸã
†æ¯é±ãŸãã¯æ¯æãç¹°ãè¿ãã§ã¡ãŒã«ãéä¿¡ããŸã
†åãã¡ãŒã«ã¹ã¬ããå
ã§ãã©ããŒã¢ããã¡ãŒã«ãéä¿¡ããŸã
ââââââââââââââââââââââââââââââââ
ðã»ãã¥ãªãã£
ã»ãšãã©ã®ããŒã¿ã¯Googleã¢ã«ãŠã³ãã®å€ã«åºãããšã¯ãããŸããïŒåä¿¡è
ãªã¹ãã¯ã¹ãã¬ããã·ãŒãã«ãã¡ãŒã«ã³ã³ãã³ãã¯Gmailâ¢ã«æ®ããŸãïŒã
詳ããã¯ããã©ã€ãã·ãŒããªã·ãŒã®ããŒã¿ã¢ã¯ã»ã¹ãšããŒã¿ä¿åã®ã»ã¯ã·ã§ã³ããèªã¿ãã ããã
https://www.mergo.app/privacy-policy
ãŸãã幎ã«äžåºŠãBishopfox ã NCC Group ãªã©ã®äŒæ¥ã«ããã»ãã¥ãªãã£è©äŸ¡ãåããŠããŸãã
ãã®è©äŸ¡ã¯ãMergoãããŒã¿ãå®å
šã«æ±ãããŠãŒã¶ãŒã®èŠæ±ã«å¿ããŠãŠãŒã¶ãŒããŒã¿ãåé€ããèœåãå®èšŒããããšã§ãGoogleãŠãŒã¶ãŒã®ããŒã¿ãå®å
šã«ä¿ã€ã®ã«åœ¹ç«ã¡ãŸãã
https://help.mergo.app/article/95-mergos-security-assessment
ââââââââââââââââââââââââââââââââ
ð€ ãªãç«¶åä»ç€Ÿã§ã¯ãªãMergoã䜿ãã®ã§ããïŒ
Google WorkspaceããŒã±ãããã¬ã€ã¹ã§ã¯ãã¡ãŒã«ãã£ã³ããŒã³ãè¡ãããã®å€ãã®ã¢ããªãæäŸãããŠããŸãã
Mergoã¯ãæ°äžä»£ã®Googleã¢ããªã³ã§å®å
šã«æ§ç¯ãããæåã®ãã®ã§ãããŠã§ããã©ãŠã¶ã§å®è¡ããããã¹ãŠã®ã³ãŒãã¯ãGoogleã«ãã£ãŠæäŸããä¿è·ãããŠããŸãïŒã»ãã¥ãªãã£äžã®è
åšãšãªãããã«ã¹ã¿ã HTMLãJavascriptãGmassã®ããã«Gmailâ¢ãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ã®ãããã³ã°ã¯è¡ãããŸããïŒã
Mailmeteorã®ããã«ãMergoã»ã©Gmailâ¢ãšçµ±åãããŠããªããã®ããããŸããGmailâ¢ã®äžæžãã䜿ããªãã£ãããè¿ä¿¡ã远跡ã§ããªãã£ãããåãã¡ãŒã«ã¹ã¬ããã§ãã©ããŒã¢ãããå®è¡ã§ããªãã£ããããŸãã
ââââââââââââââââââââââââââââââââ
䜿çšäŸ
ãŸã çŽåŸããŠããŸãããïŒMergoã§éãããšãã§ããã¡ãŒã«ãã£ã³ããŒã³ã®äŸãããã€ãã玹ä»ããŸã:
†ãªãŒããžã§ãã¬ãŒã·ã§ã³ãã£ã³ããŒã³ïŒGoogleã³ã³ã¿ã¯ãããŸãã¯CSV圢åŒã®CRMïŒSalesforceãHubSpotãCopperãªã©ïŒããGoogle Sheetsã«é£çµ¡å
ãã€ã³ããŒãããŸããMergoã䜿çšããŠãèŠèŸŒã¿å®¢ã«ã¿ãŒã²ãããçµã£ãã¡ãŒã«ãéä¿¡ããèŠèŸŒã¿å®¢ãéããªãããã«ããŸãïŒ
†ã»ãŒã«ã¹ããã¹ãã¯ãã¡ãŒã«ïŒã¢ã«ãŠã³ããããŒãžã£ãŒã¯ãããŒãœãã©ã€ãºãããã¡ãŒã«ãã¿ãŒã²ããã«éä¿¡ãã顧客ã®ããŒããã©ãªãªãç°¡åã«ç®¡çã§ããMergoã®ã·ã³ãã«ããæ°ã«å
¥ãããšã§ããããSalesforce List EmailsãPardotãHubSpotãMailChimpãSendGridãGetResponseãMailerLiteããããã£ãšäœ¿ããããã§ãã
†ã€ãã³ãã®æåŸ
ç¶ïŒMergoã®ããŒãœãã©ã€ãºãããæ·»ä»ãã¡ã€ã«ãšã¹ã±ãžã¥ãŒã«æ©èœã䜿çšããŠãã²ã¹ããé©åãªã¿ã€ãã³ã°ã§é©åãªæåŸ
ç¶ãåãåããããã«ããŸããäŒæ¥ã€ãã³ããçµå©åŒãåã³ã³ã補åçºè¡šäŒãã»ãããŒããç¥ãããã§ã¢ãå°±è·æŽ»åãªã©ãããŸããŸãªã€ãã³ãã«æåŸ
ç¶ãéããŸãããïŒ
†ããã¢ãŒã·ã§ã³ïŒå²åŒã¯åŒ·åãªé¡§å®¢ç²åŸãšç¶æããŒã«ã«ãªãåŸãã®ã§ããã®æ©äŒãéããªãããã«ããŸãããïŒå€/å¬ã®ã»ãŒã«ããã©ãã¯ãã©ã€ããŒãåå賌å
¥æãªã©ã«ã¯ãŒãã³ãå²åŒåžãéããŸããã...
†ãã¥ãŒã¹ã¬ã¿ãŒ/ããŒã±ãã£ã³ã°ãã£ã³ããŒã³ïŒè£œåããµãŒãã¹ã«é¢ãããã¥ãŒã¹ã¬ã¿ãŒã宿çã«éä¿¡ãã誰ãã¡ãŒã«ãéããã¯ãªãã¯ããåå¿ãããã远跡ããŸãã顧客ãšã³ã²ãŒãžã¡ã³ããé«ããããã«ããªã¹ãããããŠã³ã¹ãåé€ããæ¬¡ã®ãã£ã³ããŒã³ãæ¹åããŸãã
†顧客æºè¶³åºŠèª¿æ»ïŒé¡§å®¢ããææçŸ©ãªãã£ãŒãããã¯ãåŸãããšã§ãããžãã¹ãšããã»ã¹ãæ¹åããããšãã§ããŸãã
†瀟å
ã³ãã¥ãã±ãŒã·ã§ã³ïŒç®¡çè·ãšç€Ÿå¡ã人äºéšãšããŒã ãäºåå±ãšä¿è·è
ãæåž«ãšçåŸãªã©ãããããã³ãã¥ãã±ãŒã·ã§ã³ãå¹çåããŸããé¢ä¿è
ãCCãŸãã¯BCCåä¿¡è
ãšããŠã¡ãŒã«ã«è¿œå ããã°ãéèŠãªæ
å ±ãèŠéãããšã¯ãããŸããã
†ã°ãªãŒãã£ã³ã°ã¡ãŒã«ïŒã¯ãªã¹ãã¹ã®ãç¥ããæ°å¹Žã®æšæ¶ãæè¬ç¥ãäŒæ¥ã®æšæ¶ãåºçéç¥ãæè¬ã®ã¡ãŒã«ãªã©ãããªãã®å人ãå®¶æãååãå£äœã®ã¡ã³ããŒã«éä¿¡ããŸã...
†ã¡ãã£ã¢ãã£ã³ããŒã³ïŒãžã£ãŒããªã¹ããããã¬ãŒãã€ã³ãã«ãšã³ãµãŒã«PRãã£ã³ããŒã³ãè¡ãã補åã®èªç¥åºŠãäžããŸãã
†ãªãã€ã³ããŒãã£ã³ããŒã³ïŒæ¯æãåŸæ¥å¡ã«ãªãã€ã³ããŒãéä¿¡ããCRMãœãªã¥ãŒã·ã§ã³ã«çµè²»ãç»é²ããããäŸé ŒããŸãã
Mergoã¯ãScriptitã®Romain Vialardã«ãã£ãŠäœæãããŸããã
Romainã¯Yet Another Mail Merge (YAMM)ãAwesome Table & Form Publisherã®äœè
ã§ããããŸãã圌ã¯ãããããã®è£œåã«é¢äžããŠããŸããïŒçŸåšã¯Talarianã«ãã£ãŠã¡ã³ããã³ã¹ãããŠããŸãïŒã
Romainã¯Google Developer Expert (GDE) ããã°ã©ã ã®ã¡ã³ããŒã§ã10 幎以äžã«ããã£ãŠGoogle Apps ScriptãšGoogle APIã«æºãã£ãŠããŸãã