Sending multiple URSs from attachment field in airtable via single email

Newbie here so apologies if this has been explained in the community already.

My goal is to send a new record from table including multiple images in attachment field in a single gmail.

I can send email with all data and only the first image of the attachment field successfully.

Looking through the community posts I tried using iterator and/or aggregator but I cannot seem to get it right. I only want to send URL not as attachment so I am suspecting http module isn’t needed here.

Could someone please shed a light on this?

Here is the data source in airtable.

Ultimately I would like to send a collection of thumbnails with link to the actual image file

I can send only the first image.

Welcome to the Make community!

1. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

2. And most importantly, Output bundles

Please provide the output bundles of the Airtable module by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes

Thank you for your prompt response, samliew.

Here is the json file.
blueprint.json (90.5 KB)

txt file isn’t allowed so here is the output bundle.

[
{
“fldQSASzGaMHzzx7A”: “2023-07-29”,
“fldyTrAPX1HugmyDH”: “checked”,
“fldaXtCITjOiBKS9M”: “checked”,
“fldioMyYCloCwBZ3u”: “checked”,
“fldd6Q6KpiVmb6PNk”: “checked”,
“fldjE8UA9SJ0WOKB2”: “checked”,
“fld35ztTQMtstNyre”: “checked”,
“fld5yfMlHoTuEan3z”: “TV software uploarded. テレビのソフトウェアの更新”,
“fldABdhTWnlLNl6Uy”: “by the celling had a water damage. シーリングに一部が少し膨らんでいます。エバンと相談します。”,
“fldY8tJprTxg78NjB”: “checked”,
“flddN0hDEhvteE3XN”: “checked”,
“flduIvmnar6IxYXYq”: “checked”,
“fld4sTGzY9PMhbZ0U”: “tighten the right side handle. 右側のドアの取っ手のぐらつきを締め直しました。”,
“fldZAC1Yz4ONhcVae”: “checked”,
“fldm8NjjwotKUwsnL”: “checked”,
“fldsGpZNt8gM6mCra”: “checked”,
“fld3HlPNp8ucw6B5o”: “checked”,
“fldKIbZQFbsozgiNu”: “checked”,
“fldllc7YAMn04N4Kc”: “had change new faucet. キッチン蛇口交換済”,
“fldbXncSQnZnXOqbD”: “checked”,
“fldGfYXwK8prI4FFH”: “checked”,
“fldzWEgRCy7AxgZkO”: “checked”,
“fldgdQUHxaZngWqCj”: “checked”,
“fldK2H24678on243L”: “checked”,
“fldLIRUUHWDnCxIw0”: “checked”,
“fldXEOluBRDXcuCj4”: “checked”,
“fldoBI6ktY0mDE7zE”: “checked”,
“fld7S28PObfIbMfwY”: “checked”,
“fldNwUzj0wUFz1UIF”: “checked”,
“fld4Q4dkA4Bl075AS”: “had change new faucet. 洗面台蛇口交換済”,
“fldvcpFQ0rZg0xsLq”: “checked”,
“fld5kfOVICoDpu9XM”: “checked”,
“fldEV1qBI7nONBKIT”: “checked”,
“fldW5MVIn3fGKswoy”: “checked”,
“fldRwWBaMnlxNkqpF”: “checked”,
“fldtTC04nUS4kgdi2”: “checked”,
“fldHUmhFuvok2Fdqj”: “checked”,
“fldVWzLdiqahvdT3j”: “checked”,
“fldznSaM2je3sQBOE”: “checked”,
“fldSGMhLsn3z0ODQb”: “checked”,
“fldQ5Uhljrumsmm4W”: “checked”,
“fldNbcq25e5LPVDTs”: “checked”,
“fldBG9gQicCj8GfUN”: “checked”,
“fldZDW5vDBW8de3yF”: “checked”,
“fldU8qfGZNK4NWnJA”: “checked”,
“fld1uDEn8iEMbRIAa”: “checked”,
“fld0KDY4XzaDzeysB”: “checked”,
“fldfJZQBS1U4oSMAL”: “checked”,
“fldMFZMIwyXYgT9M2”: “checked”,
“fldzTzl1IJDDiZHE9”: “checked”,
“fldrPMUNBuqI4Ljgz”: “checked”,
“fld42ZCkP2R3Tn4mB”: “checked”,
“fldFhikt2zNFtPsTX”: “checked”,
“fldzcQQ6aQbJZYBPz”: [
{
“id”: “attGGSKz0OGIuHy3b”,
“width”: 1202,
“height”: 672,
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/bFwPIiMPxH-H210rjvOFKQ/KwWtcxI31uNA2CwW84CaNoh7JDO4lq77FgRsYPbXUOhw8fSkDQ9uA_oXzYsm5-wr3z2L_g7aCQjI0SfeX0RVnvUz16yjCbNYXzcy8Q_wKcaoy3e9IEpf_StB-4Lel5tu5upvJWUFsXRyhZSJwtNkhQ/KvO0TCUOpkE8xrXBCHf4U4XlR2FuR2aEx6hZ8zP7nu8”,
“filename”: “Bird of Paradise.png”,
“size”: 1567186,
“type”: “image/png”,
“thumbnails”: {
“small”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/1wshKt5lynRSJ2iaUFkmBA/PGnv0otgWXbbcAu6UFpC5jTR8-mUOnJU343bMXC2h4l2yl-HiAcnUumzq-4edTBMkofku5H7FbQHcCjZLSEBuge6hvM0GDd6X9t0W7QqlknV2nvTy3bDnFo3Jl2teFjs4FnCZ5gWF4lsXAIwIKAqZQ/lA4BfIlwKnjhHrAbhUBN3OV_WvoBXeQ8M_bFD6K7OZI”,
“width”: 64,
“height”: 36
},
“large”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/IDzwgcGo0wU5rO5dvmi6QA/TEHl32qIaiMH6_VaMxi54Wrn2jTzAWBTTky4lQ_H2vUpYkRRFigLqwhPut6Y79XM7cINXMVrs378xIpmGw9uepCukn_Jjt4iNg9U-u9TgbaTonnFUjMRGcHN1ic8xq0W0l95nA_VhIqhb33W6MWzCQ/mqTR_bbApBxoJ4Qn5CAm_xQvTAtOtaXQStA3xmEKlz0”,
“width”: 916,
“height”: 512
},
“full”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/Gum0HcgvVDV3Fxo4QV7BAg/OtxOwFOQoJ7TsI3_y4d2bA4BuswwNfMbV2pO3XATdfN1YKOULi46RUSvvfJXi2KjFCPq69OrM5-12WAEWW7HSntl8ctcYw4CBg1PZ-CyXrK4w_4udyZfQKNUx2YsXwJylZPgRmOUIcBy-txb6oAwFw/ghQIRT_wmMo0qlwyUiaXdTMZDtf2P0uUsRLmVWBo5uU”,
“width”: 1202,
“height”: 672
}
}
},
{
“id”: “attzblqgND2Ns7IGp”,
“width”: 1242,
“height”: 784,
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/dusm4UElilte8HfKngYI-A/fTR58DSfdxp9_M1k58oAEuVh0PPPP9qirc5Z0vJnW9_iNum3BbvLFeSNmrvS0uFUyYONGAUkb7iiTfhe9cJShE0_OCsTnlKkIkQUeW37986RdQAl6Oaa1A7R6Je8atfl5VCtbCNWuyL8HvFelUB_kQ/279iJr1-BoxIJlwAXn7a5T6XclxJDmaSRuyZnDPGHJM”,
“filename”: “Bottle Brush Tree.png”,
“size”: 1994957,
“type”: “image/png”,
“thumbnails”: {
“small”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/nZXwLXrXyE_pPzIxPEuCeQ/aTYfAYsopBPJpruwIX_KeiPrvmAu3Xv2F13yEVRAnToFIUWSDz0ZQNNOk_bzZ6bZxkp7eMJ1WqbRKlZFCxNg-9lRk4Zp7POjiu_OGpXQJRYcKCfAj6Ai31LsW12W-0y5KFLKrwGQzm_Apb8RTEkgxQ/O6OJrJCGHIO_keHIGRNEYtoGINGAX6lsolqR1JgLNxg”,
“width”: 57,
“height”: 36
},
“large”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/MzHsXciIF1pDYExW3TkPKA/5IkraA_D2qAk45Ov8eNCGzttekyx9hwjxWlURtYjKNNOAnJWvPbgMDBJXoqtaYpf2RpLXwhM6PIqD0eBCw3XGxmTgNt_SM-qADR5BRL6ByePmi3mBWvhFOugCp7huotvzV-bHVmYKpGDFM2qj8o7bw/T0TMWyxObziaIWPCuZH1lIOunzva6m1NMpHSa4Lz-pk”,
“width”: 811,
“height”: 512
},
“full”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/AJWAVOlq3gWJJ-f6-aTS8A/H9D8ExEl1FObqdggFYlTQRyjljQWbiYJHu5OJ7uIh03YJC_kAxIanj9hV9i3zY7OFYVTSNLYqeEv-y5BhTrv1MhWbwaVfq15dHiwe8VaO-xtnD8uVdeCQcY749dqOc4dPMQbbPXbwhWQ_krcoRTfBA/jDLw8Uq72aALuweD9LZxP97xbgjL2zWu0RArso8PilY”,
“width”: 1242,
“height”: 784
}
}
}
],
“fldK4d0zHXgcyI9DQ”: “checked”,
“fldr5QO8RbUoTJUOu”: “checked”,
“fldEvY2rUvDSzwDMr”: “checked”,
“fldDwaRgQE0sM2sLc”: “checked”,
“fldEG8Qub6cPgwlPh”: “a”,
“fldq8yveybvlmWaCh”: [
{
“id”: “att45A6IoBUhzRNFS”,
“width”: 985,
“height”: 406,
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/3aNa8li0IUDOff-ahevAvg/_0trOPyDpPLCLHwg6yWSQSUrgD-42T8Mu6pK9Q4D8_LHe0LMNQ42PAPfRdujpbuFncWacFKGEYXuw4kjNp7Lujc_kFcnCDecDIZ4Nr-lSmOeaMjDc4rJJPUhIqfkHkKU-krO2iKPbKl1mDuYPNarIBA5lBik5N5wC6F7q9BVI5o/g-5mjDFSlhmoZFjdvXb-5tfhZ12UKseKOFpjOIQcw5I”,
“filename”: “Screenshot 2024-01-18 202904.jpg”,
“size”: 46434,
“type”: “image/jpeg”,
“thumbnails”: {
“small”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/m8g9EkRdcOPaFkWimjhkBA/FfumUgnjUMvjy2MmjJJHpgIpSuXGJSsKio3wxJ4PrpMvU113JctwPdR8arqD930Qhf-qJ7MlrUh1RPhJmAptm9yfV8fbVeLoFs-v2vzOTQ-j9AP2Q2kqiBNXZEQSAjZiq1zCUC3n1Jr_1gRSxQjDEg/U0SYJaGR04WpkgtsSl9XXMMjT20pXNb7sG0Sz21nHO8”,
“width”: 87,
“height”: 36
},
“large”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/xW-kOEYxccT062DiklBGjw/_ji9Hmcg2DIcDuMXKYnvcHuXOAzRY0D2voZHJ1nO1Iqxd9NyU7t80-gknuwgKLlyby_PWWh4MTtTRVuijMrhTBEvx8AtjqLswulMAUjz1pm1HcmxM1jQxhMpv3uXZpWLPFkXJ4VBVopvwv_V-axQeA/fyu0FCsMcrW7CC7GWfuSeOIpc55z8jG9zZInXSSXNFY”,
“width”: 985,
“height”: 406
},
“full”: {
“url”: “https://v5.airtableusercontent.com/v3/u/25/25/1706234400000/lL9QL4XDAr5fDj7sAXCQDw/LhJy5m0skjpG7w2CcdwpzWj0oixmC3qW5egvoTnf0bzMTeLg_Y3O4abOPJFFN9circLhKFR3VzB38CDY_5fgb8duYuyokBjj9PvK9pIwbx4BamZltIGxwbVu3pbb3bEiGirdHP5Qh_aNW4CFbRUxaw/RAQ2Ree1qewtRApZQGLu1zVpSH-KTFvPToaHxbqrVxw”,
“width”: 985,
“height”: 406
}
}
}
],
“fldXfNjVMZsYw12io”: “checked”,
“fld9gF6KQFRtnqSAg”: “checked”,
“fldjACCdCXm9fLwXu”: “checked”,
“fldEpTLMi2wURmnK5”: “checked”,
“fld6G3dP4EGJecAKx”: “checked”,
“fldVX6VcuE8eDI3tj”: “had tip on the top of the tank. タンク上部に表面に欠けがあります。少し修復法を考えてみます。”,
“fldSq38lxjmk4MLn6”: “checked”,
“fldYjjj4y4BiyNXj9”: “checked”,
“fldKKB8w7hGut2fXB”: “checked”,
“fldYrwNsNzRbNVlQ8”: “checked”,
“fldTmHos3dtD2qVlL”: “2024-01-25T23:02:39.000Z”,
“id”: “recBsvs5kyDONenL7”,
“createdTime”: “2024-01-25T23:02:39.000Z”
}
]

After watching a tutorial
I managed to run this scenario.

iterators run on an attachment field.

then http module downloads the images[even though this isn’t exactly my goal, I only wish to extract URLs]

put them through aggregator. by selecting all I can pass other data to gmail also.

Here is a exported blueprint of this test scenario.
blueprint (1).json (114.6 KB)

Any tip to make this happen would be greatly appreciated. Thank you.
Evan

Hey @eggsta
I think this will help you

Turn off “Map”

And you will find all the fields like this

It will help if you send an attachment with a name and content ID.

Additionally, the “add an attachment” will help you send multiple attachments.

2 Likes

Thank you @Abhishek, unfortunately this won’t work for me as my goal is to send an array of URLs in the mail content not as attachment.

Hi Folks, solved it. I just needed to use Text Aggregator to bundle up URLs between Iterator and Gmail modules. all good, Aloha

3 Likes

Hi @eggsta welcome to the community :wave:

I’m just quickly stepping in to say great work figuring this one out :clap:

Thanks a lot for coming back into the thread and sharing what did the final trick for you. This is super valuable and could be incredibly helpful to others searching for similar information :pray:

1 Like