Google Sheets

With Google Sheets integration, you can easily create any image from your data without the need of external tools.

Setting Up Google Sheets

Open the Google Sheets file and select to Tools > Script Editor

In the newly open tab, click on the + icon next to Libraries section then paste this ID into the Script ID field before clicking on Look up button

1CDMOeQtf4PEPqCgJF5C08pQdY38BwaJfCvmqAj1zvKLYbipe8bv-zke_

Select the latest version from the dropdown list then click Add button

Replace the Code.gs content with below before hitting Save project button

/**
 * Generate image for a template with custom data
 *
 * @param {string} apiKey The API key acquired in Dynapik dashboard
 * @param {string} template The Template ID used to generate images
 * @param {string|Array<Array<string>>} fields The header range contains all fields in the template
 * @param {string|Array<Array<string>>} data The data used to replace inside the template
 * @return The URL of the generated image
 * @customfunction
 */

function DYNAPIK(apiKey, template, fields, data) {
  return Dynapik.generateImage(apiKey, template, fields, data)
}

Using Custom Function