Shopify Gift Card Importer Google App Script

gift_card_google_script.js

const sheet = SpreadsheetApp.getActive().getSheetByName("[sheet_name]");
const data = sheet.getDataRange().getValues();

function postData(giftData) {
  
  let options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : JSON.stringify(giftData),
    'headers': {
      'Authorization': "Basic " + Utilities.base64Encode("[api_key]:[api_password]")
    }
  };

  UrlFetchApp.fetch("https://[store-name].myshopify.com/admin/api/2021-10/gift_cards.json", options);
};

function iterateThroughRows() {
  data.forEach(function (row) {

    let giftData = {
      "gift_card": {
        "initial_value": row[2],
        "code": row[0],
        "customer_id": row[1]
      }
    };

    postData(giftData)
  });
};

Google Script to be used for importing a Google Sheet of gift card information into Shopify.

Requires a private app to be set up in the Shopify store with access to the Gift Card API.

When you Run the script in Google Scripts, make sure you select the iterateThroughRows function first.