Instagram and glide combined

[Alexander_Rubino]

I want to have a list of 5 pictures in my app, that all come from an Instagram account. So you can click on the image, and you will be sent to the Instagram account.
I want to be sent to this Instagram account, with this picture: BC Copenhagen on Instagram: "KAMP I HORSENS! Vi tager nu hul på sæsons 3 kamp, og skal endnu engang en tur til Jylland og møde Horsens IC 💪🏻👊🏻 Drengene har haft en lidt svær start på sæsonen, hvor vi har tabt de 2 første kampe. Nu hedder modstanderen altså Horsens IC! Horsens har selv kun spillet 1 kamp i denne sæson, som de vandt 64-90 over Holbæk. Sidst vi mødte Horsens var i sidste sæson, hvor drengene hiv sejren hjem! Bliver en spændende kamp som drengene er rigtig klar til! 🏀 📍Forum Horsens 🕰 15:00 📺 Basketligaen.dk Lets go Copenhagen! #connectingcopenhagen #heroesofcopenhagen #basketball #basketligaen #københavn #nørrebrohallen #valbyhallen #ballislife #bccopenhagen #basketballclubcopenhagen"

Bonus:
Is it possible to just have the 5 latest posts on Instagram be shown? Because that would be even better.

Do I need to use the web embed function to make this happen?

[ThinhDinh]

I did some research, and it seems like most “aggregators” out there outputs a piece of HTML + JS code for you to “embed” a customized Instagram feed.

How to Embed Your Instagram Feed On Your Website - Curator

Some require you to have an Instagram business account, I’m not sure if your account is a business account or not.

If the option above doesn’t work, maybe you can try connecting your Instagram account to a service like Make/Zapier/n8n. Everytime there’s a new post, write a line to your Google Sheets, and only display the last 5 lines, for example, in an inline list.

[Alexander_Rubino]

So I have tried the Zapier solution, but it didn’t seem to work that great. So I’m trying the solution you suggested now @ThinhDinh. I’m stuck at the step “Step 6: Copy the HTML code into your site”. I have copied the HTML, but where do I print it into glide?
I know it’s been a while since I started this thread, but hope you can help.

[Jeff_Hager]

You can embed HTML using a rich text component, but if that code includes javascript, then it won’t work. Glide does not allow javascript to be embedded and ran directly on a screen. Best bet is to maybe try placing the code in a web embed component. If that doesn’t work, then you’ll have to host on another website and embed that website with the web embed component.

[Alexander_Rubino]

When I put it in a Rich Text, it makes a link with the text “Powered by Curator.io”
This is the HTML:

Powered by Curator.io

<div id="curator-feed-default-feed-layout"><a href="https://curator.io" target="_blank" class="crt-logo crt-tag">Powered by Curator.io</a></div><!-- The Javascript can be moved to the end of the html page before the </body> tag --><script type="text/javascript">
/* curator-feed-default-feed-layout */
(function(){
var i,e,d=document,s="script";i=d.createElement("script");i.async=1;i.charset="UTF-8";
i.src="https://cdn.curator.io/published/66bef0b8-a238-45ab-9951-51ccb4b07df8.js";
e=d.getElementsByTagName(s)[0];e.parentNode.insertBefore(i, e);
})();
</script>
type or paste code here

[Jeff_Hager]

That has javascript, so it won’t work with a rich text component.

However, I did figure out a trick that seems to work. A

• Add a new text column in your table. Name it “embed” or something like that.
• Temporarily add a file picker component and point it to that new column.
• Take that embed code and paste it into notepad or some other basic text editor. Save the file as embed.html or something like that.
• Use the file picker to upload that html file to the glide database.
• Now add a web embed component and point it to that new column which now contains the html file.

You’ll end up with something like this.

[Alexander_Rubino]

I have a question. Does this update when a new post gets posted on the Instagram?

[Jeff_Hager]

I assume it would be no different than embedding the code on any other website. If that includes automatically updating, then I’d say yes, it should, however I don’t know for sure how that code from curator.io is designed to work.

[ThinhDinh]

What a workaround!

[Jeff_Hager]

Yeah, I was thinking about third party hosting, then it hit me that we already have a host. Just need the HTML document. I think this could come in handy for a lot of things. Now if only we could figure out a way to dynamically generate that html document.

[Alexander_Rubino]

I have run into a problem with this method. It doesn’t seem to update automatically. Have I done something wrong? Or is it not possible with this method? It is very essential for this app

[Jeff_Hager]

I don’t know. I only figured out the method as I was responding to you, so it’s new to me too. It’s probably cached until the web view is refreshed. You could maybe find some javascript to add to that html page that will cause it to auto refresh after a certain amount of time.

[Alexander_Rubino]

I found out curator updates the posts every 24 hours.
I have an interesting follow-up.
2 posts have been added to the instagram today, but for some reason, it only shows one of them in curator. All of the posts that are getting shown have different hashtags, but the one post missing does not. Do you think the posts have to have hashtags, for them to get shown in curator?

Link to the post without hashtags (doesn’t show in curator): BC Copenhagen on Instagram: "KAMP LØRDAG! Så er der kamp lørdag og turen når ned til det sydfynske, hvor modstanderen er Svendborg rabbits! 💪🏻 Copenhagen har nu vundet 3 af deres seneste kampe og jagter nu nummer 4! Der bliver lagt op til en meget tæt og underholdene lørdag eftermiddag i Svendborg Idrætscenter! 🔥 ⏰: Lørdag d. 29.10 klokken 16:00 📍: Svendborg Idrætscenter 📺: Link til kampen kommer kampdag! LETS GO COPENHAGEN"

[Jeff_Hager]

I don’t know how curator works or how you came up with that embed code, so I can’t help you there. I’m guessing it’s some sort of setting with how you generated that embed code. I don’t know if you set it up to look at specific hashtags, or if you set it up to look at specific feeds. That may be a question for the curator team.

[gvalero]

WTF??

You deserve a Jeff!!

[Joe_Gabriele]

Hey Jeff, just wondering if any of the new computed columns or random genius thought you have would allow the html file to be dynamically generated so users could upload their own reels links vs instructing them to do the workaround themselves .

[Darren_Murphy]

It’s possible. Both Jeff & I have tinkered with it. Essentially you just need to generate the HTML with a template, use JavaScript to URIencode that, and then use the URIencoded HTML in a web view component.

The following JavaScript works:

return `data:text/html;charset=utf-8,${encodeURIComponent(p1)}`;

[Joe_Gabriele]

Thanks Darren,

So just to confirm:

• First, use a Text Column which stores the HTML code.
• Then use a Temp Column, which is setup like TEXT.html, where TEXT is replaced by the Text Column.
• Next, use a Javascript Column and point “p1” to the Temp Column
• Lastly, use Web Embed and use the Javascript Column?

[Darren_Murphy]

No, not exactly. Specifically your second step there doesn’t really make sense to me.

What you need is to start with a HTML document inside a text or template column. And I don’t mean an actual document, I mean all the HTML code. Here is an example of one I was playing around with a while back:

The above template column produces the following:

And then that column is URIencoded with the JavaScript, which produces something that looks like:

And then that is used in the web view.

In the example above I used a template column for the HTML, because it needed to be dynamic. But it doesn’t have to be. It could be a plain text column if it’s just static HTML.

[Joe_Gabriele]

Alright, I guess I am confused now I’ll just add the code I am trying to display below. This is a Instagram Reels Embed Code

“<blockquote class=”“instagram-media”" data-instgrm-captioned data-instgrm-permalink=““Crafted Catering and Events on Instagram: "Officially Wedding Season, and looking forward to celebrating! Let us give you your lovely day! Reach out today, link in bio."”” data-instgrm-version=““14"” style=”" background:#FFF; border:0; border-radius:3px; box-shadow:0 0 1px 0 rgba(0,0,0,0.5),0 1px 10px 0 rgba(0,0,0,0.15); margin: 1px; max-width:540px; min-width:326px; padding:0; width:99.375%; width:-webkit-calc(100% - 2px); width:calc(100% - 2px);“”><div style=““padding:16px;””> <a href=““Crafted Catering and Events on Instagram: "Officially Wedding Season, and looking forward to celebrating! Let us give you your lovely day! Reach out today, link in bio."”” style=“” background:#FFFFFF; line-height:0; padding:0 0; text-align:center; text-decoration:none; width:100%;“” target=“”_blank"“> <div style=”" display: flex; flex-direction: row; align-items: center;“”> <div style=““background-color: #F4F4F4; border-radius: 50%; flex-grow: 0; height: 40px; margin-right: 14px; width: 40px;””> <div style=““display: flex; flex-direction: column; flex-grow: 1; justify-content: center;””> <div style=“” background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; margin-bottom: 6px; width: 100px;“”> <div style=“” background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; width: 60px;“”><div style=““padding: 19% 0;””> <div style=““display:block; height:50px; margin:0 auto 12px; width:50px;””><svg width=““50px”” height=““50px”” viewBox=““0 0 60 60"” version=”“1.1"” xmlns=““SVG namespace”” xmlns:xlink=““XLink namespace””><g stroke=““none”” stroke-width=““1"” fill=”“none”" fill-rule=““evenodd””><g transform=““translate(-511.000000, -20.000000)”” fill=“”#000000"“><path d=”“M556.869,30.41 C554.814,30.41 553.148,32.076 553.148,34.131 C553.148,36.186 554.814,37.852 556.869,37.852 C558.924,37.852 560.59,36.186 560.59,34.131 C560.59,32.076 558.924,30.41 556.869,30.41 M541,60.657 C535.114,60.657 530.342,55.887 530.342,50 C530.342,44.114 535.114,39.342 541,39.342 C546.887,39.342 551.658,44.114 551.658,50 C551.658,55.887 546.887,60.657 541,60.657 M541,33.886 C532.1,33.886 524.886,41.1 524.886,50 C524.886,58.899 532.1,66.113 541,66.113 C549.9,66.113 557.115,58.899 557.115,50 C557.115,41.1 549.9,33.886 541,33.886 M565.378,62.101 C565.244,65.022 564.756,66.606 564.346,67.663 C563.803,69.06 563.154,70.057 562.106,71.106 C561.058,72.155 560.06,72.803 558.662,73.347 C557.607,73.757 556.021,74.244 553.102,74.378 C549.944,74.521 548.997,74.552 541,74.552 C533.003,74.552 532.056,74.521 528.898,74.378 C525.979,74.244 524.393,73.757 523.338,73.347 C521.94,72.803 520.942,72.155 519.894,71.106 C518.846,70.057 518.197,69.06 517.654,67.663 C517.244,66.606 516.755,65.022 516.623,62.101 C516.479,58.943 516.448,57.996 516.448,50 C516.448,42.003 516.479,41.056 516.623,37.899 C516.755,34.978 517.244,33.391 517.654,32.338 C518.197,30.938 518.846,29.942 519.894,28.894 C520.942,27.846 521.94,27.196 523.338,26.654 C524.393,26.244 525.979,25.756 528.898,25.623 C532.057,25.479 533.004,25.448 541,25.448 C548.997,25.448 549.943,25.479 553.102,25.623 C556.021,25.756 557.607,26.244 558.662,26.654 C560.06,27.196 561.058,27.846 562.106,28.894 C563.154,29.942 563.803,30.938 564.346,32.338 C564.756,33.391 565.244,34.978 565.378,37.899 C565.522,41.056 565.552,42.003 565.552,50 C565.552,57.996 565.522,58.943 565.378,62.101 M570.82,37.631 C570.674,34.438 570.167,32.258 569.425,30.349 C568.659,28.377 567.633,26.702 565.965,25.035 C564.297,23.368 562.623,22.342 560.652,21.575 C558.743,20.834 556.562,20.326 553.369,20.18 C550.169,20.033 549.148,20 541,20 C532.853,20 531.831,20.033 528.631,20.18 C525.438,20.326 523.257,20.834 521.349,21.575 C519.376,22.342 517.703,23.368 516.035,25.035 C514.368,26.702 513.342,28.377 512.574,30.349 C511.834,32.258 511.326,34.438 511.181,37.631 C511.035,40.831 511,41.851 511,50 C511,58.147 511.035,59.17 511.181,62.369 C511.326,65.562 511.834,67.743 512.574,69.651 C513.342,71.625 514.368,73.296 516.035,74.965 C517.703,76.634 519.376,77.658 521.349,78.425 C523.257,79.167 525.438,79.673 528.631,79.82 C531.831,79.965 532.853,80.001 541,80.001 C549.148,80.001 550.169,79.965 553.369,79.82 C556.562,79.673 558.743,79.167 560.652,78.425 C562.623,77.658 564.297,76.634 565.965,74.965 C567.633,73.296 568.659,71.625 569.425,69.651 C570.167,67.743 570.674,65.562 570.82,62.369 C570.966,59.17 571,58.147 571,50 C571,41.851 570.966,40.831 570.82,37.631"”><div style=““padding-top: 8px;””> <div style=“” color:#3897f0; font-family:Arial,sans-serif; font-size:14px; font-style:normal; font-weight:550; line-height:18px;“”>View this post on Instagram<div style=““padding: 12.5% 0;””> <div style=““display: flex; flex-direction: row; margin-bottom: 14px; align-items: center;””>

<div style=““background-color: #F4F4F4; border-radius: 50%; height: 12.5px; width: 12.5px; transform: translateX(0px) translateY(7px);””>

<div style=““background-color: #F4F4F4; height: 12.5px; transform: rotate(-45deg) translateX(3px) translateY(1px); width: 12.5px; flex-grow: 0; margin-right: 14px; margin-left: 2px;””> <div style=““background-color: #F4F4F4; border-radius: 50%; height: 12.5px; width: 12.5px; transform: translateX(9px) translateY(-18px);””><div style=““margin-left: 8px;””> <div style=“” background-color: #F4F4F4; border-radius: 50%; flex-grow: 0; height: 20px; width: 20px;“”> <div style=“” width: 0; height: 0; border-top: 2px solid transparent; border-left: 6px solid #f4f4f4; border-bottom: 2px solid transparent; transform: translateX(16px) translateY(-4px) rotate(30deg)“”><div style=““margin-left: auto;””> <div style=“” width: 0px; border-top: 8px solid #F4F4F4; border-right: 8px solid transparent; transform: translateY(16px);“”> <div style=“” background-color: #F4F4F4; flex-grow: 0; height: 12px; width: 16px; transform: translateY(-4px);“”> <div style=“” width: 0; height: 0; border-top: 8px solid #F4F4F4; border-left: 8px solid transparent; transform: translateY(-4px) translateX(8px);“”> <div style=““display: flex; flex-direction: column; flex-grow: 1; justify-content: center; margin-bottom: 24px;””> <div style=“” background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; margin-bottom: 6px; width: 224px;“”> <div style=“” background-color: #F4F4F4; border-radius: 4px; flex-grow: 0; height: 14px; width: 144px;“”><p style=“” color:#c9c8cd; font-family:Arial,sans-serif; font-size:14px; line-height:17px; margin-bottom:0; margin-top:8px; overflow:hidden; padding:8px 0 7px; text-align:center; text-overflow:ellipsis; white-space:nowrap;“”><a href=““Crafted Catering and Events on Instagram: "Officially Wedding Season, and looking forward to celebrating! Let us give you your lovely day! Reach out today, link in bio."”” style=“” color:#c9c8cd; font-family:Arial,sans-serif; font-size:14px; font-style:normal; font-weight:normal; line-height:17px; text-decoration:none;“” target=“”_blank"“>A post shared by Crafted Catering and Events (@craftedcateringandevents)

<script async src=”“//www.instagram.com/embed.js”“>”

I have the above Embed Code pulled from Instagram. Would I still need to enter that into a plain text file, save as embed.html and upload it through the file picker and display through Web Embed? I was hoping to avoid the upload file part.

I am able to display photos, but trying to figure out a way to display video/Reels. Maybe this solution wasnt meant for that.