How to update Shopify customer metafields from Google Sheets

Please, I need urgent help. I’ve been trying to create a scenario in make.com to update customer metafields in shopify from data coming from a google sheet. I’ve created the customer metafields in shopify.

I’m having trouble getting the metafield id for the customer metafields. I tried using the id number I got from the url, but it’s not working. I’m so lost and confused. I’ve been battling this issue for a week straight. please, I’m frustrated at this point, and it’s gotten me to a point at which I don’t know what else to do.

Would you be able to assist me in figuring this out? Any guidance would be greatly appreciated. Thanks so much

1 Like

Hi @Mike_Xander

Could you please explain your requirement and challenge briefly through a loom video? This will help community to better assist you.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

Thank you so much. This is a short loom explaining my issues:

1 Like

Hi @Mike_Xander

Thank you for the brief loom. Please try using list metafields and then map the id from there as shown in image.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like

I tried it but it didn’t work out. It showed me zero bundles


1 Like

Try only passing the customer id. If it doesn’t find still, create a metafield and then check for that. Copy the payload from “create a metafield” module for future troubleshoot.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

namespace is custom , headline_3 is the key you check on shopify on the metafield it’s tell you namespace + key . Issue with the search for metafield it’s, it’s doesnt find empty metafield … im stuck at this point .

1 Like

I think I might be of help. Can you screenshot your current setup?`

1 Like

Thanks also. I got the problem solved :slight_smile: Thanks again Msquare automation. You are the best

1 Like

i just made a http request and it an issue with shopify api not even with make , people said you have to create metalfield with a default value in it , apparently it’s can be made with create metafield, because of that the metafield you make directly in shopify will be working for manual use only =( still trying to check if a request with graphQl can solve the issue as i was doing it with the rest api.

1 Like

Okay. could you help with a screenshot of your current setup. This would be really helpful

1 Like

I am having a similar issue, are you @Msquare_Automation may able to help me?

I do find now the metafields (with deleting namespace & key from the module), but somehow I am not able to update them.

1 Like

What is the error you are recieving?? @Julian_AUT

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

The Problem with the metafields is now gone - but a new Issue is in the pipeline:

How to Display Non-HTML Formatted Text in Rich Text Metafields for a Clean User-Friendly Layout?

I’m working with rich text metafields to store and display product information on my Shopify store. My goal is to provide a clean, structured, and user-friendly layout for product details, applications, and instructions without relying on HTML formatting.

Here’s the challenge:

Rich text metafields render HTML perfectly, but I’d prefer to avoid HTML entirely to simplify maintenance and ensure compatibility across different modules and integrations.

• I need the text to appear well-structured with clear sections (e.g., “Preparation,” “Application,” “Notes”), bullet points for lists, and numbered steps where applicable.

Current Structure:

For example, this is how I want the information to appear:

Preparation:

  • Ensure all parts are clean and free of dust and grease.

  • Gather all required tools.

Application:

  1. Position the connector at the desired location.

  2. Fix the connector using screws or bolts.

  3. Verify all screws are tightly secured.

Notes:

  • Use stainless steel screws to avoid corrosion.

  • Wear gloves to prevent injuries.

The Problem:

When using rich text metafields:

  1. Shopify doesn’t provide any built-in way to format the text without HTML.

  2. The text is rendered as plain text, but without good formatting options like headings, bullet points, or numbered lists.

My Question:

Is there a way to achieve a structured and visually appealing layout in rich text metafields without relying on HTML? Are there alternative formatting options (e.g., Markdown support or other techniques) that Shopify can handle natively for rich text metafields?

Any tips, workarounds, or advice on how to implement this effectively would be greatly appreciated!