{"id":2452,"date":"2023-02-21T11:40:57","date_gmt":"2023-02-21T11:40:57","guid":{"rendered":"https:\/\/support.spoki.com\/docs\/uncategorized\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/"},"modified":"2024-07-03T08:24:49","modified_gmt":"2024-07-03T08:24:49","password":"","slug":"how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign","status":"publish","type":"docs","link":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/","title":{"rendered":"How to populate a dynamic field via CSV upload and submit a campaign"},"content":{"rendered":"\n<p>To send customized messages with specific data, it is possible to link Spoki to external management systems or upload this information that will populate dynamic message fields directly to Spoki.<\/p>\n\n<p>Let us briefly look at the latter case:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Create an excel file<\/strong> with all the information you intend to upload to Spoki for each contact and then send to the client e.g. First name, last name, balance.<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"955\" height=\"85\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png\" alt=\"\" class=\"wp-image-1028\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png 955w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56-300x27.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56-768x68.png 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li><strong>Create the dynamic fields<\/strong> you intend to import from the file on Spoki (see <a href=\"https:\/\/support.spoki.com\/en\/docs\/platform\/dynamic-fields\/\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamic Fields<\/a>).<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1009\" height=\"657\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.19.36.png\" alt=\"\" class=\"wp-image-1029\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.19.36.png 1009w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.19.36-300x195.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.19.36-768x500.png 768w\" sizes=\"(max-width: 1009px) 100vw, 1009px\" \/><\/figure>\n\n<p><\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Use the Lists tool<\/strong> on Spoki to transform your excel file into a csv file with the characteristics provided by Spoki for importing files. This step is mandatory (<a href=\"https:\/\/support.spoki.com\/en\/docs\/platform\/manage-csv\/\" target=\"_blank\" rel=\"noreferrer noopener\">see Import CSV from lists <\/a> ).<\/li>\n\n\n\n<li>After loading the file, name the list<\/li>\n\n\n\n<li><strong>Create the template<\/strong> with the dynamic fields you intend to populate (see <a href=\"https:\/\/support.spoki.com\/en\/docs\/platform\/template-messages\/\" target=\"_blank\" rel=\"noreferrer noopener\">Template<\/a>).<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"480\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22-1024x480.png\" alt=\"\" class=\"wp-image-1032\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22-1024x480.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22-300x141.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22-768x360.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22-1536x719.png 1536w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.22.png 1710w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li><strong>Create the automation<\/strong> by entering the template approved by WhatsApp (see <a href=\"https:\/\/support.spoki.com\/en\/docs\/platform\/automations\/\" target=\"_blank\" rel=\"noreferrer noopener\">Automations<\/a>).<\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1017\" height=\"596\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.34.png\" alt=\"\" class=\"wp-image-1031\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.34.png 1017w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.34-300x176.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.38.34-768x450.png 768w\" sizes=\"(max-width: 1017px) 100vw, 1017px\" \/><\/figure>\n\n<ul class=\"wp-block-list\">\n<li><strong>Set the campaign<\/strong> (see <a href=\"https:\/\/support.spoki.com\/en\/docs\/platform\/campaigns\/\" target=\"_blank\" rel=\"noreferrer noopener\">Campaigns<\/a>) to start on the day and time you prefer. this way the sending will be fixed for all contacts. If, on the other hand, you intend to diversify the sending dates for each contact, follow the procedure at the following link: <a href=\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-start-a-reminder-message-automatically-from-spoki\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to start a reminder message automatically from Spoki<\/a><\/li>\n<\/ul>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"306\" src=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.39.39-1024x306.png\" alt=\"\" class=\"wp-image-1033\" srcset=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.39.39-1024x306.png 1024w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.39.39-300x90.png 300w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.39.39-768x230.png 768w, https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.39.39.png 1492w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>To send customized messages with specific data, it is possible to link Spoki to external management systems or upload this [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[45],"doc_tag":[],"class_list":["post-2452","docs","type-docs","status-publish","hentry","doc_category-how-to-en"],"year_month":"2026-04","word_count":204,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Emanuela Locorotondo","author_nicename":"emanuelalocorotondo","author_url":"https:\/\/support.spoki.com\/en\/author\/emanuelalocorotondo\/"},"doc_category_info":[{"term_name":"How to","term_url":"https:\/\/support.spoki.com\/en\/docs-category\/how-to-en\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki\" \/>\n<meta property=\"og:description\" content=\"To send customized messages with specific data, it is possible to link Spoki to external management systems or upload this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/\" \/>\n<meta property=\"og:site_name\" content=\"Supporto Spoki\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-03T08:24:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/\",\"url\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/\",\"name\":\"How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki\",\"isPartOf\":{\"@id\":\"https:\/\/support.spoki.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png\",\"datePublished\":\"2023-02-21T11:40:57+00:00\",\"dateModified\":\"2024-07-03T08:24:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage\",\"url\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png\",\"contentUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.spoki.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\/\/support.spoki.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to populate a dynamic field via CSV upload and submit a campaign\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.spoki.com\/#website\",\"url\":\"https:\/\/support.spoki.com\/\",\"name\":\"Supporto Spoki\",\"description\":\"Documentation for Spoki use\",\"publisher\":{\"@id\":\"https:\/\/support.spoki.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.spoki.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/support.spoki.com\/#organization\",\"name\":\"Supporto Spoki\",\"url\":\"https:\/\/support.spoki.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg\",\"contentUrl\":\"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg\",\"width\":2560,\"height\":761,\"caption\":\"Supporto Spoki\"},\"image\":{\"@id\":\"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/spokiapp\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/","og_locale":"en_US","og_type":"article","og_title":"How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki","og_description":"To send customized messages with specific data, it is possible to link Spoki to external management systems or upload this [&hellip;]","og_url":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/","og_site_name":"Supporto Spoki","article_modified_time":"2024-07-03T08:24:49+00:00","og_image":[{"url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/","url":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/","name":"How to populate a dynamic field via CSV upload and submit a campaign - Supporto Spoki","isPartOf":{"@id":"https:\/\/support.spoki.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage"},"image":{"@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage"},"thumbnailUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png","datePublished":"2023-02-21T11:40:57+00:00","dateModified":"2024-07-03T08:24:49+00:00","breadcrumb":{"@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#primaryimage","url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png","contentUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2023\/02\/Screenshot-2023-02-21-alle-12.16.56.png"},{"@type":"BreadcrumbList","@id":"https:\/\/support.spoki.com\/en\/docs\/how-to-en\/how-to-populate-a-dynamic-field-via-csv-upload-and-submit-a-campaign\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.spoki.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/support.spoki.com\/docs\/"},{"@type":"ListItem","position":3,"name":"How to populate a dynamic field via CSV upload and submit a campaign"}]},{"@type":"WebSite","@id":"https:\/\/support.spoki.com\/#website","url":"https:\/\/support.spoki.com\/","name":"Supporto Spoki","description":"Documentation for Spoki use","publisher":{"@id":"https:\/\/support.spoki.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.spoki.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/support.spoki.com\/#organization","name":"Supporto Spoki","url":"https:\/\/support.spoki.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/","url":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg","contentUrl":"https:\/\/support.spoki.com\/wp-content\/uploads\/2022\/11\/Logo_Spoki-Primary_Black-01-scaled.jpg","width":2560,"height":761,"caption":"Supporto Spoki"},"image":{"@id":"https:\/\/support.spoki.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/spokiapp\/"]}]}},"_links":{"self":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/comments?post=2452"}],"version-history":[{"count":3,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2452\/revisions"}],"predecessor-version":[{"id":4245,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/docs\/2452\/revisions\/4245"}],"wp:attachment":[{"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/media?parent=2452"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/doc_category?post=2452"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/support.spoki.com\/en\/wp-json\/wp\/v2\/doc_tag?post=2452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}