<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by ViewCourier on Medium]]></title>
        <description><![CDATA[Stories by ViewCourier on Medium]]></description>
        <link>https://medium.com/@viewcourierapp?source=rss-35d326109a3b------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*dmbNkD5D-u45r44go_cf0g.png</url>
            <title>Stories by ViewCourier on Medium</title>
            <link>https://medium.com/@viewcourierapp?source=rss-35d326109a3b------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 20:25:03 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@viewcourierapp/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Airtable Data Dictionary: Document a Base in 5 Minutes]]></title>
            <link>https://medium.com/@viewcourierapp/airtable-data-dictionary-document-a-base-in-5-minutes-7885d5a1d965?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/7885d5a1d965</guid>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[no-code]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Sat, 31 Oct 2026 02:53:06 GMT</pubDate>
            <atom:updated>2026-10-31T06:06:40.860Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><p>Disclosure: this article was written with AI assistance and reviewed by the ViewCourier team. ViewCourier is our product.</p><p>Most Airtable bases are documented in one place only: the head of whoever built them. That works until that person goes on holiday, changes jobs, or you need to move the data somewhere else and nobody remembers what “Status 2 (old)” was for.</p><p>A <strong>data dictionary</strong> fixes that. It is a plain list of every table and field in a base, with enough detail that a stranger can understand the structure without clicking through each table. This post shows what to put in one and three ways to build it, from fully manual to a five-minute export.</p><h3>Why document a base</h3><ul><li><strong>Handover.</strong> A new owner needs to know what each table is for and which fields are safe to change.</li><li><strong>Onboarding.</strong> New teammates ask fewer questions when the field list is written down.</li><li><strong>Audits.</strong> You can spot duplicate fields, unclear names, and fields that nobody fills in.</li><li><strong>Before a migration.</strong> Moving to another tool or a SQL database means mapping every field type. Airtable’s single selects, linked records and lookups do not map one to one.</li><li><strong>Before automations or scripts.</strong> Scripts and integrations break when a field is renamed. A written list, ideally with field IDs, tells you what depends on what.</li></ul><h3>What a data dictionary should contain</h3><p>For each table:</p><ul><li>Table name and a one-line purpose.</li><li>The <strong>primary field</strong> (Airtable’s first column, which labels each record in linked-record pickers).</li></ul><p>For each field:</p><ul><li><strong>Field name</strong>, and ideally the stable <strong>field ID</strong> (fld...), which survives renames.</li><li><strong>Field type</strong> (single line text, number, single select, linked record, formula, rollup…).</li><li><strong>Options</strong>: the allowed choices of single and multiple selects, number precision, date format.</li><li><strong>Linked table</strong>: which table a linked-record field points to.</li><li><strong>Formula text</strong> for formulas, and the source field for lookups and rollups.</li><li>A <strong>description</strong> in plain language: what goes in, who fills it, when it is empty.</li></ul><p>That list is the target. Now the three ways to get there.</p><h3>Way 1: Manual, using Airtable’s own UI</h3><p>Airtable shows most of this in the product, but it has no “download the structure” button. The pieces I could confirm from Airtable’s documentation and API reference:</p><ul><li><strong>Field descriptions.</strong> A field can carry a description, and Airtable’s API returns it as a description property, so anything you write here can be exported later. Writing descriptions is the single most useful habit, whichever way you export.</li><li><strong>The Base schema extension.</strong> Airtable’s Base schema extension draws a diagram of the relationships between tables: linked records, formulas that reference other fields, lookups, rollups and counts. Hovering over a field shows its type. Airtable’s help article describes it as visualization-only, so it is good for understanding how a base connects, but it is not a field list you can hand to someone.</li><li><strong>The field editor.</strong> Opening a field’s settings shows its type, options and formula.</li></ul><p>A manual dictionary is a spreadsheet or a doc where you copy this in table by table. For a base with three tables and 25 fields it takes maybe 30 minutes. For 15 tables it takes an afternoon, and it is out of date the following month. Use this when the base is small and you want to write good descriptions anyway.</p><h3>Way 2: The Airtable Web API metadata endpoint</h3><p>Airtable’s Web API has an endpoint that returns the schema of a base as JSON:</p><pre>GET https://api.airtable.com/v0/meta/bases/{baseId}/tables</pre><p>According to Airtable’s reference page (“Get base schema”), it needs a personal access token with the schema.bases:read scope, and it works on all plans. The scope covers structure only. A token with just that scope cannot read records.</p><p>Setup:</p><ol><li>Create a token at airtable.com/create/tokens. Give it only schema.bases:read and add the base.</li><li>Find the base ID: it starts with app and is in the base URL.</li><li>Call the endpoint:</li></ol><pre>curl &quot;https://api.airtable.com/v0/meta/bases/appXXXXXXXXXXXXXX/tables&quot; \ -H &quot;Authorization: Bearer $AIRTABLE_TOKEN&quot;</pre><p>The response has a tables array. Each table has name, id, primaryFieldId, fields and views. Each field has id, name, type, an optional description and an options object. For a linked-record field, options.linkedTableId holds the ID of the target table, not its name, so you have to look it up yourself.</p><p>Here is a short Python version that prints a Markdown table per table and resolves linked tables. It uses only the standard library:</p><pre>import json, os, urllib.request base = &quot;appXXXXXXXXXXXXXX&quot; req = urllib.request.Request( f&quot;https://api.airtable.com/v0/meta/bases/{base}/tables&quot;, headers={&quot;Authorization&quot;: &quot;Bearer &quot; + os.environ[&quot;AIRTABLE_TOKEN&quot;]}, ) tables = json.load(urllib.request.urlopen(req))[&quot;tables&quot;] names = {t[&quot;id&quot;]: t[&quot;name&quot;] for t in tables} for t in tables: print(f&quot;\n## {t[&#39;name&#39;]}\n&quot;) print(&quot;| Field | Type | Details | Description |&quot;) print(&quot;| --- | --- | --- | --- |&quot;) for f in t[&quot;fields&quot;]: o = f.get(&quot;options&quot;, {}) if &quot;choices&quot; in o: d = &quot;, &quot;.join(c[&quot;name&quot;] for c in o[&quot;choices&quot;]) elif &quot;linkedTableId&quot; in o: d = &quot;links to &quot; + names.get(o[&quot;linkedTableId&quot;], &quot;?&quot;) else: d = o.get(&quot;formula&quot;, &quot;&quot;) print(f&quot;| {f[&#39;name&#39;]} | {f[&#39;type&#39;]} | {d} | {f.get(&#39;description&#39;,&#39;&#39;)} |&quot;)</pre><p>That is enough for a first draft. It does not yet handle pipes inside cells, formulas that show field IDs instead of names, or the rate limit on very large accounts, so treat it as a starting point.</p><h3>Way 3: The free CLI or the free browser tool</h3><p>If you would rather not maintain that script, we published one as open source: <a href="https://github.com/viewcourier/airtable-schema-export">airtable-schema-export</a> (MIT licence). It is a single Python file, Python 3.9 or newer, standard library only, nothing to install.</p><pre>git clone https://github.com/viewcourier/airtable-schema-export.git cd airtable-schema-export export AIRTABLE_TOKEN=your_personal_access_token python3 airtable_schema_export.py --list-bases python3 airtable_schema_export.py --base appXXXXXXXXXXXXXX --out docs</pre><p>--list-bases prints the bases your token can see, so you can copy the ID. --format accepts json, md, csv or all (the default), and --out sets the output folder. For a base named &quot;Client CRM&quot; you get three files:</p><ul><li>client-crm-schema.json: the raw metadata response plus a timestamp.</li><li>client-crm-schema.md: a data dictionary, one section per table with the primary field, a field table and the list of views.</li><li>client-crm-schema.csv: one row per field (base,table,field,field_id,type,details,description,is_primary), handy for filtering in a spreadsheet.</li></ul><p>The tool resolves linked tables by name, expands formulas with the fields they reference, and lists select choices. It only needs the schema.bases:read scope, so it reads no records. The token goes only to api.airtable.com and is never written to disk. It also spaces requests under Airtable&#39;s rate limit and retries on HTTP 429.</p><p>Here is what the Markdown output looks like:</p><pre>## Clients Table ID: `tblAAAAAAAAAAAAAA`. Primary field: **Name**. | Field | Type | Details | Description | | --- | --- | --- | --- | | Name | singleLineText | | Legal name of the client | | Status | singleSelect | choices: Lead, Active, Churned | | | Monthly fee | currency | precision: 2; symbol: € | | | Orders | multipleRecordLinks | links to: Orders; inverse field: Orders.Client | |</pre><p>Note the empty description on Status. That is exactly what a dictionary is good at: it shows you which fields still need a sentence.</p><p><strong>No command line?</strong> There is also a <a href="https://viewcourier.com/tools/airtable-schema-export?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_11">free in-browser version</a>. Paste a personal access token with the schema.bases:read scope, click <em>Load my bases</em>, pick one, and click <em>Read schema</em>. Then download the result as CSV, Markdown or JSON. The page runs in your browser and the token goes directly to api.airtable.com, not to our server. You can delete the token afterwards.</p><p>What neither version exports: records, comments, automations, interfaces and permissions. Airtable’s metadata API also does not return view filters or sorts, so a view appears by name and type only.</p><h3>Which way should you pick?</h3><p>1 to 3 tables, want to write good descriptions → Way 1</p><p>You already script against the API and want custom output → Way 2</p><p>Any size base, want it done now → Way 3, browser tool</p><p>Want the file in a Git repo or a wiki → Way 3, CLI</p><h3>Keep it current</h3><p>A data dictionary decays the moment someone adds a field. Two cheap habits help:</p><ul><li><strong>Re-run it on a schedule.</strong> Put the CLI in a monthly cron job or a CI job and commit the Markdown file to a repo. A Git diff then shows exactly which fields changed, which is a free change log. If you prefer the browser tool, add a recurring calendar reminder.</li><li><strong>Keep it next to your backups.</strong> Records without structure are hard to restore, and structure without records is just a diagram. Our guide on <a href="https://viewcourier.com/guides/airtable-automatic-backup-csv?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_11">backing up an Airtable base automatically</a> covers the data side, and the schema files fit in the same folder.</li></ul><p>Finally, fill in the <strong>description</strong> field as you go. Every description you write shows up in the export automatically.</p><p>If you also want the data itself delivered on a schedule, that is what <a href="https://viewcourier.com/?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_11">ViewCourier</a> does: it emails any Airtable view as a CSV or Excel file daily, weekly or monthly. It exports views, not schema, so the two complement each other.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-document-an-airtable-base-build-a-data-dictionary-in-5-minutes-3-ways"><em>https://viewcourier.hashnode.dev</em></a><em> on October 31, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7885d5a1d965" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Scheduled Airtable Exports in 2026: 8 Ways Compared]]></title>
            <link>https://medium.com/@viewcourierapp/scheduled-airtable-exports-in-2026-8-ways-compared-3edbdf545505?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/3edbdf545505</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[no-code]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Fri, 30 Oct 2026 14:22:13 GMT</pubDate>
            <atom:updated>2026-10-31T12:27:16.991Z</atom:updated>
            <content:encoded><![CDATA[<p>Disclosure: this article was drafted with AI assistance and reviewed by the ViewCourier team. ViewCourier is our product.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*C6_sateN-weZh8ux" /></figure><p>Airtable can download a view as CSV by hand. It cannot, on its own, send you that file every Monday. If you want a scheduled export, you have eight realistic routes in 2026, and they solve slightly different problems.</p><p>This post compares them: how each works, what schedule it supports, what you get, where it breaks, and roughly what it costs. Competitor prices were read from the vendors’ public pricing pages on 30 October 2026. Prices change, so check the pages before you buy. Where I did not verify a number, I describe it in words instead.</p><h3><strong>1. Native Airtable: Download CSV</strong></h3><p><strong>How it works:</strong> open the view, use the view menu, choose <em>Download CSV</em>. The file contains the view’s visible fields and filtered records.</p><ul><li>Schedule: none. A person clicks.</li><li>You get: CSV on your computer.</li><li>Limits: manual, and attachment cells contain links that expire within hours, so an old CSV has dead links.</li><li>Cost: included in every plan.</li></ul><p>Best for one-off exports and monthly files where someone is already at the keyboard.</p><h3><strong>2. Native Airtable: an automation with “Send email”</strong></h3><p><strong>How it works:</strong> an automation with the <em>At scheduled time</em> trigger, a <em>Find records</em> step on your view, then <em>Send email</em> with the found records inserted in the body.</p><ul><li><strong>Schedule:</strong> minutes, hours, days, weeks or months, by trigger settings.</li><li><strong>You get:</strong> an email with a list or grid in the body. Not a file.</li><li><strong>Limits:</strong></li><li>The body shows at most 100 records, and extra rows are dropped without a warning.</li><li><em>Send email</em> cannot build a CSV or XLSX. It only attaches files that already sit in an attachment field (up to 100 files and 25 MB in total).</li><li>Runs count against your plan. The Free plan allows 100 automation runs per month per workspace, and <em>Run a script</em> is not available on Free. On Free, the built-in email goes only to verified base collaborators.</li><li><strong>Cost:</strong> included, within plan limits.</li></ul><p>Best for a short digest of ten rows, not for a file someone sorts in Excel.</p><h3><strong>3. Airtable scripting: extension or automation script</strong></h3><p><strong>How it works:</strong> a script reads the view and builds CSV text. The scripting extension runs inside the base when someone opens it. The <em>Run a script</em> automation action runs on a schedule, and from there you can use fetch to send the file through an email API such as SendGrid or Postmark, or upload it to a record so <em>Send email</em> can attach it.</p><ul><li>Schedule: extension: manual. Automation script: anything the trigger allows.</li><li>You get: whatever you code: CSV, XLSX via a library, or a file in an attachment field.</li><li>Limits: you own the code, the API key and the failures. Not available on the Free plan. Scripts have their own execution and request limits.</li><li>Cost: needs a paid Airtable plan, plus the email service if you use one.</li></ul><p>Best if you already write JavaScript and want everything inside Airtable.</p><h3><strong>4. Zapier</strong></h3><p><strong>How it works:</strong> a Zap with <em>Schedule by Zapier</em>, an Airtable search on your view, a step that builds the CSV, and a Gmail or Outlook step that sends it.</p><ul><li>Schedule: daily, weekly or monthly triggers are available. Frequent polling depends on plan.</li><li>You get: CSV by email, or saved to Drive or Dropbox.</li><li>Limits: the Free plan has 100 tasks per month and two-step Zaps only. A multi-step Zap needs a paid plan. Airtable searches return pages of 100 records, so large views need extra handling. Row-by-row processing can eat a free allowance in one run.</li><li>Cost: Free ($0, 100 tasks/month). Professional started from $19.99/month on the pricing page today. Billing is task-based.</li></ul><p>Best when the export is one step in a longer workflow.</p><h3><strong>5. Make</strong></h3><p><strong>How it works:</strong> a scheduled scenario: Airtable <em>Search records</em>, an aggregator that produces CSV, then an email or Drive module.</p><ul><li>Schedule: the Free plan has a 15-minute minimum interval. Paid plans can schedule down to the minute.</li><li>You get: CSV by email, or saved to storage.</li><li>Limits: every module action counts as a credit, so a scenario that touches many records can burn credits quickly. You map columns yourself and fix the scenario when a field changes.</li><li>Cost: Free ($0, 1,000 credits/month). Core was $12/month at 10,000 credits on the pricing page today.</li></ul><p>Best when you want visual building and cheap credits, and you do not mind maintaining a scenario.</p><h3><strong>6. Coupler.io</strong></h3><p><strong>How it works:</strong> Coupler.io is a data-integration platform with 400+ sources. You connect Airtable as a source and a spreadsheet, BI tool or warehouse as destination, then set a refresh schedule.</p><ul><li>Schedule: per plan. The pricing page today lists daily refresh on Starter and hourly refresh on Pro.</li><li>You get: data in Google Sheets, Excel, BigQuery or dashboards. It is built for destinations, not for emailing a CSV attachment.</li><li>Limits: Starter lists 3 accounts, 1 destination, 1 user and 5,000 rows per run. The free tier refreshes manually only, when I last checked in October.</li><li>Cost: Starter $32/month ($24 billed annually). Pro, with hourly refresh, $259/month ($199 annually).</li></ul><p>Best when Airtable is one of several sources feeding a dashboard. For one view in one sheet it is more platform than you need.</p><h3><strong>7. Google Apps Script (free, open source)</strong></h3><p><strong>How it works:</strong> one Code.gs file in a Google Apps Script project reads your view through the Airtable API, builds a CSV and sends it with MailApp. A time-driven trigger runs it. We publish a free MIT-licensed version: <a href="https://github.com/viewcourier/airtable-view-to-email-csv">airtable-view-to-email-csv</a>.</p><p>Setup in short: create a read-only Airtable token, paste the script into a new project, store the token in Script Properties, fill CONFIG, run once to authorise, then schedule it:</p><pre>// Run once from the Apps Script editor function scheduleMondayAt8() { installWeeklyTrigger(&#39;MONDAY&#39;, 8); } function scheduleDailyAt9() { installDailyTrigger(9); }</pre><ul><li>Schedule: any Apps Script time-driven trigger: hourly, daily, weekly.</li><li>You get: a CSV attachment by email (with UTF-8 BOM, so Excel shows accents correctly).</li><li>Limits: a Google account owns the script. Apps Script stops a run after 6 minutes, so tens of thousands of records are the practical ceiling. Airtable allows about 5 requests per second per base, so large views are slow. You maintain it. If the token expires, you find out when someone notices.</li><li>Cost: free, within Google’s quotas.</li></ul><p>Best if you are comfortable pasting a script and want zero monthly cost.</p><h3><strong>8. ViewCourier (our product)</strong></h3><p><strong>How it works:</strong> you connect a read-only Airtable token, pick a base, table and view, choose a format and recipients, and set a schedule in your timezone. Each run emails the view as an attachment with a dated file name. The view’s filters, sort and visible fields define the file.</p><ul><li><strong>Schedule:</strong> weekly or monthly on Free, daily on Starter, hourly on Pro.</li><li><strong>You get:</strong> CSV, Excel (.xlsx) or a PDF report attached to an email, up to five recipients. Starter and Pro also give a live CSV link for IMPORTDATA in Google Sheets.</li><li><strong>Limits:</strong> it delivers by email only. It does not write to Drive or Dropbox. It does not do minute-level schedules or other sources.</li><li><strong>Cost:</strong> Free (1 weekly or monthly export, 1,000 rows). Starter €9/month (3 exports, 5,000 rows each). Pro €19/month (25 exports, 50,000 rows each). Paid features have a 14-day trial without a card. See <a href="https://viewcourier.com/pricing?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_10">the pricing page</a>.</li></ul><h3>Side by side</h3><ul><li>Download CSV: schedule manual; output CSV file; main catch: nobody schedules it; cost: included.</li><li>Automation Send email: schedule any trigger; output email body, up to 100 records; main catch: no CSV attachment; cost: included, run limits.</li><li>Airtable script: schedule automation trigger; output whatever you code; main catch: you maintain code; cost: paid Airtable plan.</li><li>Zapier: schedule plan-dependent; output CSV via email or Drive; main catch: task counts, paging; cost: free tier, paid from $19.99/mo.</li><li>Make: schedule 15 min (Free), 1 min (paid); output CSV via email or Drive; main catch: credits per module; cost: free tier, Core $12/mo.</li><li>Coupler.io: schedule daily (Starter), hourly (Pro); output Sheets, Excel, BI; main catch: not an email attachment; cost: $32/mo and up.</li><li>Apps Script: schedule any time trigger; output CSV by email; main catch: 6-minute run limit; cost: free.</li><li>ViewCourier: schedule weekly to hourly; output CSV, XLSX, PDF by email; main catch: email only; cost: free; €9; €19.</li></ul><h3>Which one to pick</h3><ul><li><strong>One export, now:</strong> the native <em>Download CSV</em>.</li><li><strong>A short digest in an email body:</strong> an Airtable automation with <em>Send email</em>.</li><li><strong>Export is one step in a bigger workflow:</strong> Zapier or Make. Compare them in <a href="https://viewcourier.com/guides/zapier-make-alternative-airtable-csv-export?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_10">this Zapier and Make guide</a>.</li><li><strong>Airtable is one of many sources in a dashboard:</strong> Coupler.io. For one view in a sheet, see <a href="https://viewcourier.com/guides/coupler-io-alternative-airtable-to-google-sheets?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_10">this Coupler.io alternative guide</a>.</li><li><strong>You can run a script and want it free:</strong> Apps Script with the open-source repo above.</li><li><strong>A person needs a file in their inbox on a schedule, and you do not want to maintain anything:</strong> a dedicated scheduled-export tool such as ViewCourier.</li></ul><p>More tools, including EasyCSV, On2Air and CSV Getter, are in <a href="https://viewcourier.com/guides/airtable-csv-export-tools-compared?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_10">the full comparison of Airtable CSV export tools</a>. For a one-off export with no schedule, the <a href="https://viewcourier.com/tools?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_10">free browser tools</a> download a base without signup.</p><p>ViewCourier is a product of BASIT B.V. and is not affiliated with Airtable, Zapier, Make or Coupler.io.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/scheduled-airtable-exports-in-2026-8-ways-compared-free-and-paid"><em>https://viewcourier.hashnode.dev</em></a><em> on October 30, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3edbdf545505" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Airtable CSV attachment links expired? 3 ways to keep files]]></title>
            <link>https://medium.com/@viewcourierapp/airtable-csv-attachment-links-expired-3-ways-to-keep-files-fc1f03f84b52?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/fc1f03f84b52</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Thu, 29 Oct 2026 16:25:05 GMT</pubDate>
            <atom:updated>2026-10-29T19:32:02.480Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*RnD4oDAH3BsXZE-P" /></figure><p><em>This article was drafted with AI assistance and reviewed by the ViewCourier team. It is written for the ViewCourier blog. ViewCourier is our product.</em></p><p>You export an Airtable view to CSV. The attachment column is full of links, and they all work. A day later you open the file again, click one, and get an error. Nothing is wrong with your CSV or your base. The links expired, and that is how Airtable designed it.</p><p>This post explains why it happens, what a CSV export actually contains, and three ways to keep your files: a free browser tool, a script you run yourself, and a setup that keeps files outside Airtable from the start. Facts about Airtable’s behaviour come from its help center and developer docs; where something may change, I say so.</p><p>Airtable changed how attachment URLs behave on 8 November 2022. Per its documentation:</p><ul><li>In a <strong>CSV export</strong>, attachment URLs “will expire after a few hours”.</li><li>In the <strong>Web API</strong>, attachment URLs expire 2 hours after the API returns them.</li><li>Airtable’s support article promises the links stay active for <strong>at least 2 hours</strong>, and says the exact window may change.</li></ul><p>The stated reason is security. A permanent link means anyone who gets hold of it can open the file without any Airtable access. Airtable also discourages using attachment URLs as a CDN, for example as image sources on a website.</p><p>So a CSV that is a day old, a week old or a year old contains dead links. You will usually see a 403 or similar error.</p><p>An attachment field is exported as text: the file name followed by a download link, for each file in the cell. <strong>The files themselves are not in the CSV.</strong> A CSV is plain text and cannot hold a PDF or a photo.</p><p>That has practical consequences:</p><ul><li>A CSV export is a copy of your <strong>field values</strong>, not of your <strong>files</strong>. If the base holds contracts, invoices or photos, a CSV is not a backup of them.</li><li>The file names stay in the CSV, so an old export still tells you which files a record had, even when the links are dead.</li><li>Anything that uses those links later breaks: a website, a spreadsheet image formula, another tool reading the CSV next week.</li></ul><p>The same applies to API responses. If you list records through the API and store the url values in a database, you are storing links that die within hours.</p><p>The rule that follows: <strong>download the file while the link is fresh</strong>, or keep the file somewhere that does not expire.</p><p>Airtable’s interface downloads one attachment at a time, which is painful beyond a handful of records. The free <a href="https://viewcourier.com/tools/airtable-download-attachments?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_09">Download all Airtable attachments tool</a> on ViewCourier (I work on it, so weigh that accordingly) fetches them in bulk:</p><ol><li>Create a read-only personal access token at airtable.com/create/tokens with the scopes data.records:read and schema.bases:read, and give it access to the base.</li><li>Paste it into the tool and load your bases. Pick the base, the table, and optionally a view. With a view, only that view’s records are included, so its filters apply.</li><li>Tick the attachment fields and choose a folder layout: one folder per record, or flat.</li><li>Click <strong>Scan attachments</strong>. You see the number of files, the total size and the largest file. Nothing is downloaded yet.</li><li>Click <strong>Download ZIP</strong>.</li></ol><p>Details worth knowing:</p><ul><li>It runs in your browser. The token is sent only to api.airtable.com, and the files come from Airtable&#39;s file servers straight to your computer. Nothing passes through ViewCourier&#39;s server and nothing is stored. You can delete the token afterwards.</li><li>Large jobs are split into ZIP parts of up to 500 MB. The stated limit is 100,000 files and 20 GB per run. Use a desktop browser, since one part is held in memory at a time.</li><li>Each ZIP contains an attachments-manifest.csv mapping every file to its record ID, field, path, original file name, size and a status. It deliberately stores no download links, because a link that dies within hours only looks like a backup.</li><li>Links are fetched fresh at scan time and used straight away. If you scan and then wait more than about two hours, scan again. A file that fails with a 403 had an expired or refused link: scan again and retry.</li><li>It selects by field and by view, not by file type. For only images, tick a field that holds only images, or make a view with the filter you need.</li></ul><p>If you want control, or want to run this on a schedule, a script works. The rule is the same: list records, then download each URL immediately, in the same run.</p><h3>The API route: a small open-source Python script</h3><p>I have a small open-source Python script for this. Here is the core of the approach, using the requests library and a read-only token in an environment variable:</p><pre>import os, re, time, requests TOKEN = os.environ[&quot;AIRTABLE_TOKEN&quot;] BASE = &quot;appXXXXXXXXXXXXXX&quot; TABLE = &quot;Table 1&quot; FIELD = &quot;Photos&quot; # the attachment field OUT = &quot;attachments&quot; headers = {&quot;Authorization&quot;: f&quot;Bearer {TOKEN}&quot;} api = f&quot;https://api.airtable.com/v0/{BASE}/{requests.utils.quote(TABLE)}&quot; def safe(name): return re.sub(r&#39;[\\/:*?&quot;&lt;&gt;|]&#39;, &quot; &quot;, name).strip()[:120] or &quot;file&quot; offset = None while True: params = {&quot;pageSize&quot;: 100, &quot;fields[]&quot;: FIELD} if offset: params[&quot;offset&quot;] = offset r = requests.get(api, headers=headers, params=params) if r.status_code == 429: # rate limit: wait 30 seconds time.sleep(30) continue r.raise_for_status() data = r.json() for rec in data[&quot;records&quot;]: folder = os.path.join(OUT, rec[&quot;id&quot;]) for att in rec[&quot;fields&quot;].get(FIELD, []): os.makedirs(folder, exist_ok=True) path = os.path.join(folder, att[&quot;id&quot;] + &quot;-&quot; + safe(att[&quot;filename&quot;])) # download right now, while the URL is fresh with requests.get(att[&quot;url&quot;], stream=True) as f: f.raise_for_status() with open(path, &quot;wb&quot;) as fh: for chunk in f.iter_content(65536): fh.write(chunk) offset = data.get(&quot;offset&quot;) if not offset: break time.sleep(0.25) # stay under 5 requests/second per base</pre><p>Notes: the list records endpoint returns up to 100 records per page plus an offset while more remain, with a limit of 5 requests per second per base. The attachment URL is already signed, so the file request needs no Authorization header. Test on a small view before pointing it at thousands of files, and add retries if your connection is shaky. The complete script is free and open source: <a href="https://github.com/viewcourier/airtable-attachments-downloader">https://github.com/viewcourier/airtable-attachments-downloader</a></p><h3>The Airtable Scripting extension route</h3><p>The Scripting extension can read attachment URLs from a view, but it cannot save files to your computer. The usual pattern, which Airtable’s own help article uses, is to generate one curl command per file and run the commands in a terminal:</p><pre>// Scripting extension: print a curl command per attachment in a view const table = base.getTable(&quot;Table 1&quot;); const view = table.getView(&quot;Grid view&quot;); const field = &quot;Photos&quot;; const query = await view.selectRecordsAsync({ fields: [field] }); const lines = []; for (const record of query.records) { const files = record.getCellValue(field) || []; for (const file of files) { const name = file.filename.replace(/[\\/:*?&quot;&lt;&gt;|]/g, &quot; &quot;); lines.push(`curl -L -o &quot;${record.id}-${name}&quot; &quot;${file.url}&quot;`); } } output.markdown(&quot;```\n&quot; + lines.join(&quot;\n&quot;) + &quot;\n```&quot;);</pre><p>Run the output in a terminal <strong>right away</strong>, because the URLs expire in roughly two hours. Airtable describes its own version of this as a simplified example that will likely have limitations, so treat it as a starting point.</p><p>Ways 1 and 2 rescue files already in Airtable. To stop the problem coming back, make sure a durable copy exists outside Airtable.</p><p><strong>Sync new attachments to cloud storage with an automation.</strong> A Make or Zapier scenario (or an Airtable automation with a script) can fire when a record is created or updated and copy the new files to Google Drive, Dropbox, OneDrive or S3 immediately, while the link is fresh. This covers new files. Existing records need Way 1 or 2 once as a backfill.</p><p><strong>Store files elsewhere to begin with.</strong> If the files must be reachable from outside Airtable, upload them to a shared drive and keep only a link in Airtable. You give up Airtable’s built-in previews, but the links do not expire.</p><p><strong>Schedule exports so you always have a fresh CSV.</strong> Same caveat: I work on <a href="https://viewcourier.com/?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_09">ViewCourier</a>. A schedule does not make links last longer; each CSV has links that are fresh when the file is created and expire hours later. What it gives you is a dated copy of every field value, daily, weekly or monthly, without remembering to export. You connect a read-only token, pick a view, and choose a schedule and timezone. Each run emails a CSV, Excel or PDF to up to five recipients. The free plan covers one weekly or monthly export; paid plans start at EUR 9 per month, with a 14-day trial of daily schedules that needs no credit card. It does not copy the attachment files themselves, so recipients who need them must download on the day the email arrives, or you run the other ways in parallel.</p><p>Use Way 1 for an old export with dead links, Way 2 to automate or customise, and Way 3 for anything you need to keep. Many teams combine them: a one-off bulk download to catch up, an automation that copies new files as they arrive, and a scheduled CSV as a lightweight copy of everything else.</p><p><strong>How long do Airtable attachment links last?</strong> Airtable’s docs say at least 2 hours, and that API URLs expire 2 hours after being returned. CSV export links “expire after a few hours”. The window is not guaranteed and may change.</p><p><strong>Can I get fresh links for an old CSV?</strong> Not from the CSV itself; its links have expired. Export again, or fetch the records through the API, and download the files immediately.</p><p><strong>Is the file still in Airtable after the link expires?</strong> Yes, the file stays attached to the record. Only the exported or API link expires, and a new export or API call gives you a fresh one.</p><p>Airtable attachment links in CSV exports and API responses expire by design, within a few hours. A CSV holds links, not files. To keep the files, download them while the links are fresh: in bulk with the <a href="https://viewcourier.com/tools/airtable-download-attachments?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_09">free attachment download tool</a>, or with your own script. To stop it happening again, copy new files to storage you control and schedule exports for the rest. For the longer explanation with Airtable’s own wording, see the <a href="https://viewcourier.com/guides/airtable-csv-attachment-links-expired?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_09">guide on why attachment links in a CSV stop working</a>.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/airtable-csv-export-attachment-links-expired-why-it-happens-and-3-ways-to-keep-your-files"><em>https://viewcourier.hashnode.dev</em></a><em> on October 29, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fc1f03f84b52" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Weekly Email Digest of New Airtable Records (3 Methods)]]></title>
            <link>https://medium.com/@viewcourierapp/weekly-email-digest-of-new-airtable-records-3-methods-c524dd2a3807?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/c524dd2a3807</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[email]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Wed, 28 Oct 2026 15:20:56 GMT</pubDate>
            <atom:updated>2026-10-28T18:29:49.040Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*cLjRX4Zg2EOKl3K2" /></figure><p><em>This article was drafted with AI assistance and reviewed by the ViewCourier team. It is written for the ViewCourier blog.</em></p><p>A form on your website feeds an Airtable table. A sales rep adds leads by hand. A client request form drops tasks into a project base. Each produces new records all week, and the people who need to act on them rarely open Airtable at the right moment.</p><p>A weekly digest fixes that: one email, same day every week, listing what arrived since the last one. This post shows how to build the data side once (a “New this week” view) and then three ways to send it. It also covers where Airtable’s built-in options run out. Limits quoted come from Airtable’s help center; where I’m not sure of something, I say so.</p><ul><li><strong>It arrives.</strong> A view nobody opens is not a report. An email on Monday morning gets skimmed.</li><li><strong>It batches attention.</strong> Per-record notifications on a busy form turn into noise. One summary per week is easier to act on.</li><li><strong>It leaves a trail.</strong> A dated email answers “what came in during the first week of March?” without digging through a base.</li><li><strong>It reaches people outside the base.</strong> A sales manager or a client can get the list without an Airtable seat.</li></ul><p>Typical uses: inbound leads from a contact form, event registrations, feature requests, new tasks for a team, vendor sign-ups for an admin team.</p><p>Automations are the building block, but a few limits shape what a digest can look like.</p><ul><li><strong>Send email fires per trigger.</strong> “When a record is created, send an email” sends one email per record. A form with 60 submissions a week means 60 emails.</li><li><strong>A schedule is possible.</strong> The <strong>At a scheduled time</strong> trigger plus <strong>Find records</strong> can gather records into one email. Option A below uses this.</li><li><strong>The list in the email is capped.</strong> In Airtable’s documentation, the list of records inserted into a Send email body shows at most 100 records, and extras are left out without a warning.</li><li><strong>It is text, not a file.</strong> Airtable’s own support docs note there is no built-in action that converts records into a CSV. Send email attaches files that already sit in an attachment field; it does not build a spreadsheet.</li><li><strong>Recipients are restricted on Free.</strong> As I understand the current docs, on Free the action can only email verified collaborators on the base. Check the automation limits page for your plan, since these numbers change.</li></ul><p>For a short weekly list going to colleagues already in the base, native can be enough. The rest of the post helps you decide.</p><p>Every method depends on Airtable knowing when each record arrived.</p><ol><li>Open the table and click <strong>+</strong> to add a field.</li><li>Choose the <strong>Created time</strong> field type and name it Created.</li><li>Include the time, not just the date, and pick the timezone you want displayed.</li></ol><p>Created time fills in for existing records using their actual creation timestamp, so there is nothing to backfill. It is read-only, so nobody can accidentally change when a lead arrived.</p><p>Whatever this view shows is what the digest contains, so spend your time here.</p><ol><li>Create a new <strong>Grid</strong> view named New this week. Use a name a recipient could read, since some tools use the view name as the email subject.</li><li><strong>Filter:</strong> Created <strong>is within</strong> <strong>the past week</strong>. This counts seven days back from today, not the previous calendar week. A record created just before last Monday&#39;s send could appear in two consecutive digests. If that would bother you, use <strong>this calendar week</strong> and send on Friday.</li><li><strong>Sort:</strong> Created descending, newest first.</li><li><strong>Hide fields</strong> the reader doesn’t need: internal notes, formula helpers, lookups, record IDs. Hidden fields are not included in exports. Keep the name, contact detail, source, status, and whatever the reader must act on.</li><li><strong>Lock the view</strong>, so a colleague tidying filters doesn’t quietly change what gets sent.</li></ol><p>Add a test record and confirm it shows up.</p><p><strong>A ready-made starting point:</strong> there is a free base on Airtable Universe, the <a href="https://www.airtable.com/universe/expnQj9IlLrkYIIfX/inbound-leads-tracker-weekly-new-leads-digest">Inbound Leads Tracker — weekly new leads digest</a> template. It is built around exactly this use case; copy it into your workspace and adapt the fields to your form or CRM.</p><h3>Option A: an Airtable automation with Find records</h3><p>The no-code native route.</p><ol><li>Open <strong>Automations</strong> and create one named Weekly digest.</li><li><strong>Trigger:</strong> <strong>At a scheduled time</strong>, repeating weekly. Set day, time and timezone, and double-check the timezone; a wrong one means the email lands mid-afternoon or at night.</li><li><strong>Action 1: Find records.</strong> Choose the table, and under <em>Search in</em> pick the New this week view, so the filter from Step 2 does the work.</li><li><strong>Action 2: Send email.</strong> Set recipients and a subject like New leads this week. In the message, use <strong>+</strong> to insert the list of records from the Find records step, choose the fields to show per record, and add a link to the view.</li><li><strong>Test it.</strong> Use <em>Generate a preview</em> where offered. <em>Run test</em> sends a real email to the addresses you entered.</li></ol><p>What to watch for:</p><ul><li><strong>The 100-record cap</strong> in the email body. If a week can exceed 100 records, some can drop silently. A link to the full view helps but doesn’t remove the problem.</li><li><strong>No attachment.</strong> The reader gets text, not a CSV or PDF.</li><li><strong>Empty weeks.</strong> The email still goes out unless you add a condition that continues only if Find records returned at least one record.</li><li><strong>Recipients and unsubscribe.</strong> Check the rules for your plan; Airtable adds an unsubscribe link to automation emails.</li></ul><p>Good fit: colleagues who want a quick list of up to a few dozen records.</p><h3>Option B: a short script in the automation</h3><p>For more control, such as a count in the subject or a compact line per record, add a <strong>Run a script</strong> action between the trigger and the email. I’m not certain which plan tiers include scripting inside automations, so check Airtable’s current plan comparison first.</p><pre>// Run a script action: build a plain-text digest from the &quot;New this week&quot; view const table = base.getTable(&quot;Leads&quot;); const view = table.getView(&quot;New this week&quot;); const query = await view.selectRecordsAsync({ fields: [&quot;Name&quot;, &quot;Company&quot;, &quot;Source&quot;, &quot;Created&quot;], sorts: [{ field: &quot;Created&quot;, direction: &quot;desc&quot; }], }); const lines = query.records.map((r) =&gt; { const name = r.getCellValueAsString(&quot;Name&quot;); const company = r.getCellValueAsString(&quot;Company&quot;); const source = r.getCellValueAsString(&quot;Source&quot;); return `- ${name} (${company}) via ${source}`; }); const count = query.records.length; const text = count === 0 ? &quot;No new leads this week.&quot; : `${count} new leads this week:\n\n${lines.join(&quot;\n&quot;)}`; output.set(&quot;digestText&quot;, text); output.set(&quot;count&quot;, count);</pre><p>In <strong>Send email</strong>, insert digestText from the script step into the body. Use count in the subject, or in a condition to skip empty weeks.</p><p>Caveats:</p><ul><li>It is still text. A CSV attachment would mean building the file elsewhere and hosting it, which is a lot of work for a weekly email.</li><li>Query only the fields you use, and test with a realistic week of data.</li><li>It adds maintenance. If someone renames the Leads table or the view, the script breaks, and you notice only when the digest doesn&#39;t arrive.</li></ul><h3>Option C: a scheduled export tool</h3><p>The third route is to let a tool read the view and send it as a file. <a href="https://viewcourier.com/?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_08">ViewCourier</a> is one such tool, and I work on it, so weigh this accordingly. You connect Airtable with a read-only token, choose the New this week view, pick CSV, Excel or PDF, set a weekly schedule and timezone, and add recipients. The email arrives with the file attached, so recipients can sort or forward it without an Airtable account. It runs outside Airtable, so it uses no automation runs. The free plan covers one weekly or monthly export of up to 1,000 rows; paid plans start at EUR 9 per month. It is deliberately plain: an email with the file, no custom branding or written summary. Zapier or Make with extra steps to build a file can do similar jobs; pick whichever you want to maintain.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*IyB8SjOiBsoCgEpG" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*nn4vRa7g5VbK6JJv" /></figure><p>Colleagues in the base, under about 50 records a week, text is fine</p><p>A</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3N-Oop5rGBEgWP3i" /></figure><p>You want a custom summary or a count in the subject</p><p>B</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*lJVJfzJXGxGFD4pJ" /></figure><p>Recipients outside Airtable, or you want a CSV, Excel or PDF</p><p>C</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rJ5bLfQt6LgRC0Df" /></figure><p>More than 100 new records in a busy week</p><p>B or C, not a plain record list</p><p>Many teams use A for the internal quick look and C for anyone who needs the actual data.</p><ul><li><strong>The empty week.</strong> Decide whether an empty digest should send. Silence can look like breakage.</li><li><strong>Timezones.</strong> The filter, the schedule and the recipient may sit in different zones. Pick one and write it down.</li><li><strong>Duplicates across weeks.</strong> The past-week filter can repeat a record created just before the previous send. Use a fixed send time.</li><li><strong>Personal data.</strong> A leads digest contains names and contact details. Send it to named people, not a broad alias.</li><li><strong>A field added later.</strong> When the table changes, recheck what the view exposes.</li></ul><p><strong>Can Airtable email me only the new records each week?</strong> Yes, with a scheduled automation that finds records from a view filtered on a Created time field. The email body is a text list, and in Airtable’s documentation it shows at most 100 records.</p><p><strong>Can an Airtable automation send a CSV of the new records?</strong> Not on its own. Airtable’s own support docs note there is no built-in action that converts records into a CSV. You need a script plus somewhere to host the file, or an external tool that exports the view.</p><p><strong>Do I need the Created time field before the records exist?</strong> No. It fills in the real creation timestamp for existing records too, so the “New this week” filter works straight away.</p><p><strong>What is the difference between “past week” and “this calendar week”?</strong> “Past week” looks back seven days from today and can overlap with the previous digest. “This calendar week” covers the current week only, which suits a Friday send.</p><p>The reliable pattern: a Created time field, a locked “New this week” view with only the fields people need, and a scheduled send that points at that view. For a short list to colleagues, Find records is enough. For custom text, add a script. For a file people outside your workspace can open, use a scheduled export. For a longer step-by-step on the export route, see the <a href="https://viewcourier.com/guides/airtable-weekly-digest-new-records?utm_source=hashnode&amp;utm_medium=article&amp;utm_campaign=hashnode_08">weekly digest guide</a>.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-get-a-weekly-email-digest-of-new-airtable-records"><em>https://viewcourier.hashnode.dev</em></a><em> on October 28, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c524dd2a3807" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Weekly Airtable report for clients, no access needed]]></title>
            <link>https://medium.com/@viewcourierapp/weekly-airtable-report-for-clients-no-access-needed-1f818129e09d?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/1f818129e09d</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[reporting]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Tue, 27 Oct 2026 16:50:04 GMT</pubDate>
            <atom:updated>2026-10-27T19:56:48.191Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Se38FUMN2aQQ2tT2" /></figure><p>Disclosure: this article was written with AI assistance and reviewed before publishing. ViewCourier, the tool mentioned, is our product.</p><p>Picture a small agency with ten clients and one Airtable base. Every Monday each client expects a short status: what shipped, what is in progress, what is blocked. Someone on the team builds that by hand, ten minutes per client, and it goes wrong the one week that person is on holiday.</p><p>The data is already in Airtable. The clients are not, and you probably don’t want them to be. This post covers how to get the right slice of the base to the right client every week, what each delivery method costs in effort and limits, and where it breaks. The Airtable limits quoted come from Airtable’s help center; where I don’t know something, I say so.</p><p>For one trusted client on a dedicated base, it can work. For ten clients in a shared base it causes problems:</p><ul><li><strong>Access is broader than the view.</strong> Airtable’s docs say a base invite gives access to the base’s data, its automations and every interface built on it, at the permission level you choose. Your other clients’ records sit in the same tables.</li><li><strong>Seats can cost money.</strong> Read-only collaborators and shared view links aren’t billable, but Commenters and above are on the Team plan, and Editors and above on paid plans generally. A client who wants to comment takes a paid seat.</li><li><strong>Interfaces need an account.</strong> An interface shared by invitation can only be opened by someone signed in to Airtable. Plenty of clients won’t log in to a tool they didn’t choose.</li><li><strong>Nothing arrives.</strong> A dashboard nobody opens is not a report. Clients react to what lands in their inbox on Monday morning.</li></ul><p>So the working model is: keep the base private, build one narrow view per client, and send that view out.</p><p>Whatever the view shows is what the client gets, so this step matters more than the delivery method.</p><p>For each client, create a grid view with a name a client could read, such as Report: Northwind, not Grid view 14. Then:</p><ol><li><strong>Filter on the client.</strong> For a single select field use <em>is</em>. For a linked record use <em>has any of</em> and pick the client.</li><li><strong>Filter on the period.</strong> <em>Is within the past week</em> counts seven days back from today, not the previous calendar week, so a Monday report can repeat items from the Monday before. For each item exactly once, use <em>this calendar week</em> and send on Friday, or filter on a status such as “Done”.</li><li><strong>Hide internal fields.</strong> Notes, hours, cost, margin. Hidden fields are not exported.</li><li><strong>Sort</strong> by status or latest change.</li><li><strong>Lock the view</strong> so a colleague tidying filters doesn’t quietly change what a client receives.</li></ol><p>Build the first one carefully, duplicate it nine times and change only the client filter. Before any client sees a report, open the view in a private window. If you can see a field, assume the client will.</p><p>There are four realistic options, and none is best in every case.</p><p>In the view’s share menu, create a read-only link. No account is needed, and per Airtable’s docs shared view links aren’t billable. You can add a password or a domain restriction (which forces an Airtable login) and switch off “Allow viewers to copy data out of this view”.</p><p>It is always current and costs nothing to run. The downsides: without a password or domain restriction anyone holding the link can open it, and links get forwarded; nothing arrives in the inbox, so clients forget it; and there is no record of what they saw last week. It suits a client who already checks a live board.</p><p>The built-in route is an automation with an <strong>At a scheduled time</strong> trigger, a <strong>Find records</strong> action on the client’s view, then <strong>Send email</strong> with the records inserted in the body and a link to the view. Limits to know before building ten of these:</p><ul><li><strong>Find records</strong> returns up to 1,000 records per run by default. Actions created before the “Maximum record limit” setting existed find 100, so check older ones.</li><li>The list or grid in the email body shows at most <strong>100 records</strong>, and the docs say extras are left out without a warning. A busy week can look complete when it isn’t.</li><li>It sends a table, not a file. The action attaches only files already in an attachment field; it doesn’t build a CSV or PDF.</li><li><strong>Recipients.</strong> On Free, Send email reaches only verified collaborators on the base. On Team, Airtable lists 100 unique non-collaborator addresses per day.</li><li><strong>Runs.</strong> Per workspace per month: 100 on Free, 25,000 on Team, 100,000 on Business, and failed runs count. Ten weekly clients is roughly 40 to 50 runs a month.</li><li><strong>Unsubscribe.</strong> Every Send email message carries an unsubscribe link, with suppression per base. A client who clicks it stops all automation emails from that base, and on a shared mailbox one click silences the whole alias.</li><li><strong>Testing.</strong> <em>Run test</em> sends real email to everyone in To, CC and BCC. Use <em>Generate a preview</em> first.</li></ul><p>You need one automation per client, or conditional logic inside one. Per Airtable’s getting-started article a base allows 75 automations on Free, 100 on Team and 150 on Business, so ten is fine.</p><p>Both can run on a timer, search an Airtable view and send mail through Gmail, Outlook or SMTP, which sidesteps Airtable’s outside-recipient rules. For a file, you add steps to build and attach it.</p><p>They make sense when the report combines Airtable with another tool, such as invoice status from accounting software. For “this view to this inbox” they are more moving parts than the job needs, and both bill in their own usage units, so check how a per-record step scales on a 200-row view. I haven’t compared current prices, so I won’t quote any.</p><p>A different category: tools whose only job is to read a view and email it as a file. <a href="https://viewcourier.com/">ViewCourier</a> is one, and I work on it, so weigh this description accordingly. It connects with a read-only Airtable token ( data.records:read and schema.bases:read) and emails a CSV, Excel or PDF daily, weekly or monthly to up to five recipients, in a timezone you choose. Because it runs outside Airtable, it uses no automation runs and the client needs no account.</p><p>For the agency that is ten exports, one per client view, each with that client’s addresses. The email subject comes from the view name (another reason to name views readably) and the body is short and fixed. There is no logo or custom cover text, so a client who expects a branded written summary will find it plain. The Free plan includes one weekly or monthly export, so ten clients need a paid plan; check the pricing page for current limits.</p><p>For a one-off PDF with no schedule, the <a href="https://viewcourier.com/tools/airtable-view-to-pdf">free Airtable view to PDF tool</a> does a single conversion.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*_yXDhEWvHYtfdkzA" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*lRtZ0SBNofN-jBu0" /></figure><p>Reads it and files it</p><p>PDF</p><p>Fixed layout, opens anywhere, hard to edit by accident</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*uUSD7DvcSJyssfp6" /></figure><p>Sorts, totals or pivots it</p><p>Excel (.xlsx)</p><p>Numbers stay numbers; the header row is easy to filter</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2W4Hqi1KJAgg5yWh" /></figure><p>Loads it into another system</p><p>CSV</p><p>Smallest and most portable</p><p>Details that bite:</p><ul><li><strong>PDF</strong> is a snapshot of a table. Wide views get cramped, so keep the client view to the columns they care about.</li><li><strong>CSV</strong> double-clicked in Excel can show “CafÃ©” instead of “Café”. Have the client use <em>Data &gt; From Text/CSV</em> with UTF-8, or send Excel instead.</li><li><strong>Dated file names</strong> such as northwind-2026-11-02.pdf answer &quot;what did you send in November?&quot; without anyone digging through Airtable.</li></ul><p>For most agency status reports, PDF is the sensible default, with Excel for the one client who has a finance team.</p><ul><li><strong>The empty week.</strong> If nothing matches, the client gets an empty report and wonders if something broke. Decide in advance whether you want that. ViewCourier can skip sends when a view has no records; in an Airtable automation you add a condition.</li><li><strong>Wrong send time.</strong> Airtable schedules use the timezone of the device that configured them. Pick the client’s Monday morning, not yours.</li><li><strong>Formulas using </strong><strong>TODAY().</strong> They refresh on Airtable&#39;s own schedule, not at midnight, so send a few hours after midnight if a filter relies on one.</li><li><strong>A field added later.</strong> Re-check each client view whenever the table’s structure changes.</li><li><strong>Sensitive data.</strong> A report with personal or financial data now sits in an inbox and backups. Send to named people, not a shared mailbox.</li><li><strong>One recipient list, two clients.</strong> Keep recipients attached to each client’s own export or automation. A shared list with clever filtering is how a client gets another client’s numbers.</li><li><strong>Silent failures.</strong> A revoked token or deleted view makes a schedule fail. Put one internal address on every send so you notice when something doesn’t arrive.</li></ul><ol><li>Build the ten views and lock them.</li><li>Give clients who just want a glance a password-protected shared link.</li><li>For clients happy with a table in the email, use an Airtable automation, mindful of the 100-record cap.</li><li>For clients who need a file, use a scheduled export tool, or Zapier/Make if the report mixes apps.</li><li>Put an internal address on every send for the first month.</li></ol><p>Most agencies end up mixing two of these. What matters is that each client receives only their own slice, on a schedule, with no login to maintain. The guide on <a href="https://viewcourier.com/guides/send-weekly-airtable-report-to-clients">sending a weekly Airtable report to clients</a> has a longer step-by-step comparison.</p><p><strong>Can a client without an Airtable account get a report?</strong> Yes. A shared view link or an emailed file needs no account. An interface shared by invitation does.</p><p><strong>Is a shared view link private?</strong> It is read-only, but anyone with the link can open it unless you set a password or domain restriction.</p><p><strong>Can an Airtable automation attach a CSV?</strong> Not one it generates. Send email attaches only files already in an attachment field.</p><p><strong>How do I send each client a different report?</strong> One filtered view per client, then one automation or scheduled export per view, each with that client’s recipients.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-send-a-weekly-airtable-report-to-clients-without-giving-them-airtable-access"><em>https://viewcourier.hashnode.dev</em></a><em> on October 27, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1f818129e09d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Download an Airtable view or base as CSV]]></title>
            <link>https://medium.com/@viewcourierapp/download-an-airtable-view-or-base-as-csv-147e5d3eec29?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/147e5d3eec29</guid>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[csv]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Mon, 26 Oct 2026 18:53:43 GMT</pubDate>
            <atom:updated>2026-10-26T21:59:34.725Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6fE12yVQXXqDM4bQ" /></figure><p>Disclosure: drafted with AI assistance and checked by the ViewCourier team, which builds a tool mentioned below.</p><p>Downloading a CSV from Airtable takes four clicks, until the menu item you’re looking for isn’t there. Then you’re staring at a view with no <strong>Download CSV</strong> option and a colleague waiting for the numbers.</p><p>This post covers the normal route, the reasons the option goes missing and the fix for each, the Excel problems that show up after you’ve downloaded the file, how to export a whole base, and what to do if you want the export to repeat on its own. Where a claim comes from Airtable’s help center, I say so. Where the docs are silent, I say that too, rather than guess.</p><ol><li>Open the base and go to the <strong>grid view</strong> you want.</li><li>Click the small down arrow to the right of the view’s name.</li><li>Click <strong>Download CSV</strong>.</li></ol><p>What ends up in the file depends on the view. Records hidden by its filters are not exported, and neither are hidden fields (Airtable says all field values <em>visible in the view</em> are included). Record-level comments, field descriptions, base guide content and data stored only in extensions are never included. For a complete table, create a grid view called “Export — all” with no filters and every field shown, and leave it alone.</p><p>One more detail from the docs: a view with more than 5,000 visible records first loads as a 1,000-record preview with a <strong>Load all records</strong> button. The help center doesn’t say what a CSV downloaded during the preview contains, so click <strong>Load all records</strong> first and compare the file’s row count with the record count in the app.</p><p>Interfaces have their own export. According to Airtable’s Interface Designer article, the builder has to switch on <strong>Allow users to export data as CSV</strong> in the page’s properties. An end user then clicks the <strong>…</strong> icon at the top right of the page and chooses <strong>Download data</strong>. The file is named after the interface page.</p><p>If you don’t see that option, the builder probably hasn’t enabled it; the help center says you may need to find someone else to turn it on. If you are the builder, edit the page, select the visualization, enable the setting, and <strong>publish</strong>. Clicking <strong>Done</strong> only saves a draft that other people won’t see.</p><p>Two things to know. An interface page reads from a <em>table</em>, not a view: the help center says filters, sorts and hidden fields from a base view don’t carry into the interface, so the page’s own <strong>Filter by</strong> conditions decide which records can be exported. And for public interface links, exporting data such as a CSV requires the viewer to be logged in to Airtable with at least read access to the base.</p><p>The docs don’t say whether an interface export follows end-user filters or on-screen column order, so download one and check it against the page before sending it on.</p><p>Shared view links have a switch called <strong>Allow viewers to copy data out of this view</strong>. Airtable’s docs say that turning it off disables CSV download for people using the link, and the link’s creator controls it. Ask them to enable it, or ask for access to the base itself. Per the same docs, filters a viewer applies on a shared link aren’t reflected in the CSV, which always reflects the original shared view, and the setting can’t stop base or workspace collaborators from downloading.</p><p>The help center notes that if you don’t see <strong>Download CSV</strong>, an admin of an Enterprise organization may have restricted it in the admin panel’s data settings. If the option vanished for you but not a colleague, ask your admin. There’s nothing on your side to toggle.</p><p>Airtable’s documentation describes CSV export under the heading “Exporting grid views as CSVs”. The pages I checked don’t say whether Kanban, Calendar, Gallery, Timeline or List views offer the same menu item, so I won’t claim either way. If the item isn’t there:</p><ol><li>Create a new <strong>grid view</strong> on the same table.</li><li>Use <strong>Copy another view’s configuration</strong> (in the view menu) to copy filters, sorting and field visibility from your Kanban or Calendar view. The docs note that the copyable options vary by view type, so adjust a few things by hand.</li><li>Download the CSV from the grid view.</li></ol><p>The help center says exporting grid views to CSV is only available in the web and desktop apps. Open the base in a browser or the desktop app instead.</p><p>Double-clicking a CSV is where the pain starts. Excel guesses the encoding and the data types, and with accents, non-Latin scripts or currency symbols it often guesses wrong. You get “CafÃ©” instead of “Café”.</p><p>Import it instead:</p><ol><li>Open a blank workbook.</li><li>Go to <strong>Data &gt; From Text/CSV</strong> and pick the file.</li><li>In the preview, set <strong>File Origin</strong> to <strong>65001: Unicode (UTF-8)</strong>.</li><li>Click <strong>Load</strong>, or <strong>Transform Data</strong> if a column should stay as text.</li></ol><p>Then check:</p><ul><li><strong>Leading zeros vanish.</strong> 00417 becomes 417 if Excel decides it&#39;s a number. Set postal codes and IDs to Text on import.</li><li><strong>Dates flip.</strong> 03/04/2026 is March 4 or April 3 depending on regional settings. Test a row where the day is above 12.</li><li><strong>Long numbers get rounded.</strong> Excel keeps 15 significant digits, so a 16-digit ID is altered. Import it as text.</li><li><strong>Everything lands in one column.</strong> In some regional settings Excel expects a semicolon rather than a comma. The import dialog lets you pick the delimiter.</li><li><strong>Multi-select and linked-record fields</strong> arrive as one cell with the values joined together.</li><li><strong>Formula-looking text.</strong> A cell starting with =, +, - or @ can be interpreted as a formula by spreadsheet software, so be careful with CSVs containing text typed in by outsiders.</li></ul><p>Airtable doesn’t produce .xlsx directly. Its docs suggest opening the CSV in Excel and using <strong>File &gt; Save As</strong> to save a workbook.</p><p>An attachment field comes through as a filename plus a URL. Airtable’s help center says that as of November 8, 2022, attachment URLs obtained through CSV export expire after a few hours. So the CSV isn’t a place to keep attachments: if a downstream system needs the files, fetch them while the links are fresh, or download them from the records separately.</p><p>Airtable’s pages describe this slightly differently. One says attachment fields appear as filename and URL; another says attachments aren’t included in CSV exports at all. Check your own file for the attachment column before you rely on either.</p><p>Airtable has no “download base as CSV” button. The help center says exporting a full base as a single file isn’t supported, and that each table must be downloaded as its own CSV. For a base with 15 tables, that’s 15 unfiltered views to check, 15 downloads and 15 files to rename.</p><p>Ways to shortcut it:</p><ul><li><strong>Do it by hand</strong>, with an “Export — all” view per table. Tedious, but no setup.</li><li><strong>Use the API with a script.</strong> The REST API can list tables and read records, so a short script can loop through every table. You need a personal access token, some code, and pagination handling.</li><li><strong>Use a browser tool.</strong> ViewCourier has a free <a href="https://viewcourier.com/tools/airtable-base-to-csv">Airtable base to CSV tool</a> that downloads every table as a CSV inside one ZIP, running in your browser. Create a token with data.records:read and schema.bases:read, limit it to the one base, and revoke it afterwards. As with any tool that asks for a token, check where the processing happens before pasting one in.</li></ul><p>An API export gives you records, not comments or a view’s on-screen layout. Linked records, lookups and formulas come out as values, not live relationships.</p><p>A single download is fine for a one-off. If someone needs the same file every Monday, you have a few options.</p><p><strong>Airtable automations with a script.</strong> Automations can run on a schedule, and the <strong>Run a script</strong> action can read records and send data elsewhere. Airtable lists these limits for that action: a 30-second script timeout (the docs mention a temporary increase to 120 seconds), the Airtable scripting API timing out after 12 seconds, 512 MB of memory, 50 fetch requests and 30 selectRecords queries per run, and a 6 MB cap on output. Automation runs are capped monthly by plan: the docs list 100 on Free, 25,000 on Team, 100,000 on Business and 500,000 on Enterprise Scale. On the Free plan, <strong>Run a script</strong> is unavailable and <strong>Send email</strong> can only email collaborators on the base. A script that builds a CSV and delivers it is possible, but you write and maintain it, and big tables push against those timeouts.</p><p><strong>Workflow tools</strong> like Zapier or Make can read Airtable on a schedule and write to a spreadsheet or file store. They’re flexible, but you build the workflow and pay for runs.</p><p><strong>A scheduled email export.</strong> If the goal is “this view, as a file, in these inboxes, every week”, <a href="https://viewcourier.com/">ViewCourier</a> does that: you connect a view, pick CSV, Excel or PDF, set a schedule and recipients, and it emails the file. Filters, sorting and visible fields come from the view in Airtable, so you change the export by editing the view. There’s a longer walkthrough in the guide on <a href="https://viewcourier.com/guides/airtable-download-csv">downloading Airtable views as CSV</a>.</p><p><strong>Can I download a CSV of everything in the base at once?</strong> Not as one file in Airtable itself. It’s one CSV per table.</p><p><strong>Why is there no Download CSV in my Kanban or Calendar view?</strong> Airtable’s docs only describe the export for grid views. Make a grid view on the same table and copy the configuration across.</p><p><strong>Why do accented letters look broken in Excel?</strong> Excel misread the encoding. Use <strong>Data &gt; From Text/CSV</strong> and set the file origin to UTF-8.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-download-an-airtable-view-or-whole-base-as-csv-and-fix-a-missing-download-csv-option"><em>https://viewcourier.hashnode.dev</em></a><em> on October 26, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=147e5d3eec29" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Export Airtable to Excel (Free + Weekly Auto Email)]]></title>
            <link>https://medium.com/@viewcourierapp/how-to-export-airtable-to-excel-free-weekly-auto-email-1c8def3cbb61?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/1c8def3cbb61</guid>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[automation]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Sun, 25 Oct 2026 20:54:42 GMT</pubDate>
            <atom:updated>2026-10-26T00:00:02.213Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*LepHrumz0K8arQnZ" /></figure><p>This article was drafted with AI assistance and reviewed by the ViewCourier team.</p><p>Airtable is good for storing and organizing data. Excel is still where a lot of people want that data when it’s time to build a pivot table, send a report to finance, or hand something to a colleague who doesn’t have an Airtable seat.</p><p>Getting from one to the other is easy once. Keeping it current is where it gets tedious. This post covers six ways to export Airtable to Excel, from a single download to a file that arrives in your inbox every week, and says what each one can’t do.</p><ul><li><strong>Download CSV, open in Excel:</strong> free, manual, one snapshot.</li><li><strong>Power Query with the Airtable API:</strong> free, refreshable inside Excel, needs a token and some setup.</li><li><strong>Free browser tool:</strong> free, gives you a real .xlsx, manual each time.</li><li><strong>Zapier, Make and similar:</strong> flexible, but you build and pay for the workflow.</li><li><strong>Scheduled emailed Excel file:</strong> automatic, no code, a free tier for one weekly or monthly export.</li></ul><p>This is the built-in route, and it’s fine for a one-off.</p><ol><li>Open the base and the grid view you want.</li><li>Click the down arrow next to the view’s name.</li><li>Click <strong>Download CSV</strong>.</li></ol><p>Per Airtable’s help center, CSV export from a grid view is available in the web and desktop apps, and the file contains the field values visible in that view. So the view’s filters, sorting and hidden fields decide what you get. If you want every record in the table, use a view with no filters and all fields shown. Each table has to be downloaded separately. Attachment fields come out as a filename and a URL, and things like record comments and field descriptions aren’t included. If the person who shared the view has restricted copying of base data, the download option may be switched off for you.</p><p>Also from Airtable’s documentation: a view with more than 5,000 visible records initially loads as a 1,000-record preview in the app. If you have a big table, check the row count of the file you actually got.</p><p>Double-clicking a CSV is where most Excel problems start. Excel guesses the encoding and the data types, and it often guesses wrong. A more careful way:</p><ol><li>In a blank workbook, go to <strong>Data &gt; From Text/CSV</strong>.</li><li>Choose the file.</li><li>Set <strong>File Origin</strong> to <strong>65001: Unicode (UTF-8)</strong> if accented letters or other non-English characters look garbled.</li><li>Click <strong>Transform Data</strong> instead of <strong>Load</strong> if you want control over column types.</li></ol><p>The usual traps:</p><ul><li><strong>Leading zeros disappear.</strong> Postal codes, phone numbers and IDs like 00417 become 417 because Excel treats them as numbers. In Power Query, set those columns to <strong>Text</strong> before loading.</li><li><strong>Dates get reinterpreted.</strong> 03/04/2026 can be March 4 or April 3 depending on your regional settings. Airtable&#39;s date format and your Excel locale may not match. Check a few rows where the day is above 12.</li><li><strong>Long numbers turn into scientific notation.</strong> Anything over 15 digits is also rounded by Excel, so treat long IDs as text.</li><li><strong>Text that starts with </strong><strong>=, </strong><strong>+, </strong><strong>- or </strong><strong>@ can be read as a formula.</strong> Be careful opening CSVs from sources you don&#39;t trust.</li><li><strong>Multi-select and linked records</strong> arrive as one cell of comma-separated text. They won’t split into separate columns on their own.</li></ul><p>As far as Airtable’s help center documents it, the export from a grid view is CSV. Airtable’s own page on third-party data says that to get an XLSX, PDF, TSV or Numbers file you first download the CSV and convert it. We did not find a built-in option that downloads a grid view directly as .xlsx.</p><p>We also did not find a built-in setting that emails you a view export on a schedule. Airtable’s Automations can run on a schedule and send emails, and they can include data from records, but that is a different thing from attaching a file export of a view. If Airtable has added something since this was written, the help center is the place to check.</p><p>That gap is why the rest of this list exists.</p><p>If you’re comfortable in Excel’s Power Query editor, you can pull records straight from Airtable’s REST API and refresh them with a button. Excel then stores the query, not a file you have to re-download.</p><ol><li>In Airtable, open the <strong>Builder hub</strong> and go to <strong>Personal access tokens</strong>.</li><li>Create a token with the scope data.records:read.</li><li>Under access, add only the base you need.</li></ol><p>Treat the token like a password. Anyone with the workbook can see what’s inside the query, so don’t share the workbook widely if the token is in it.</p><p>In Excel, choose <strong>Data &gt; Get Data &gt; From Other Sources &gt; Blank Query</strong>, open the <strong>Advanced Editor</strong>, and paste something like this. Replace the base ID, table, view and token.</p><pre>let BaseId = &quot;appXXXXXXXXXXXXXX&quot;, TableName = &quot;Table 1&quot;, ViewName = &quot;Grid view&quot;, Token = &quot;patXXXXXXXXXXXXXX.xxxxxxxx&quot;, BaseUrl = &quot;https://api.airtable.com/v0/&quot; &amp; BaseId &amp; &quot;/&quot; &amp; Uri.EscapeDataString(TableName), GetPage = (offset as nullable text) as record =&gt; let Q = [pageSize = &quot;100&quot;, view = ViewName], Q2 = if offset = null then Q else Q &amp; [offset = offset], Result = Json.Document( Web.Contents(BaseUrl, [ Query = Q2, Headers = [Authorization = &quot;Bearer &quot; &amp; Token] ]) ) in Result, Pages = List.Generate( () =&gt; GetPage(null), each _ &lt;&gt; null, each if Record.HasFields(_, &quot;offset&quot;) then GetPage(_[offset]) else null ), AllRecords = List.Combine(List.Transform(Pages, each _[records])), FieldRecords = List.Transform(AllRecords, each [fields]), ColumnNames = List.Distinct(List.Combine(List.Transform(FieldRecords, Record.FieldNames))), AsTable = Table.FromList(FieldRecords, Splitter.SplitByNothing(), {&quot;fields&quot;}), Expanded = Table.ExpandRecordColumn(AsTable, &quot;fields&quot;, ColumnNames, ColumnNames) in Expanded</pre><p>We haven’t run this exact snippet in every version of Excel, so treat it as a starting point and expect to adjust it.</p><ul><li><strong>Pagination.</strong> The API returns at most 100 records per request and includes an offset value when there are more. The List.Generate step follows it until it&#39;s gone. Without that step you would get only the first page.</li><li><strong>Empty fields.</strong> Airtable leaves empty fields out of each record, which is why the code builds the column list from the union of all field names.</li><li><strong>Lists and records in cells.</strong> Multi-selects, linked records, lookups and attachments arrive as lists or records. Excel shows them as List or Record until you expand them or combine them into text with Text.Combine.</li><li><strong>Rate limits.</strong> Airtable limits requests per base (5 per second at the time of writing). A few thousand rows is fine. Very large tables need care.</li><li><strong>Privacy prompts.</strong> The first time you run it, Excel will ask about data privacy levels and credentials. Choose <strong>Anonymous</strong> for the web source, because the token is sent in the header.</li><li><strong>Refresh.</strong> It refreshes when you open the workbook or click <strong>Refresh All</strong>. It does not run while the file is closed, so it’s not a scheduled export. For that you’d need Power Automate, Excel on a server, or similar.</li></ul><p>If you want a proper Excel file and don’t want to write M code, ViewCourier has a <a href="https://viewcourier.com/tools/airtable-to-excel">free Airtable to Excel tool</a>. You paste in a personal access token, pick the base, table and view, and it builds the .xlsx in your browser. The export happens client-side, and the token stays in the browser.</p><p>This is still a manual step each time you want a new file, so it’s best for ad hoc exports where you want something cleaner than a CSV. As with any tool that asks for a token, use a read-only token limited to the one base, and revoke it from Airtable’s token page when you’re finished.</p><p>Automation platforms such as Zapier and Make have Airtable modules and can write to Excel (through Microsoft 365) or to a file in cloud storage. Common patterns:</p><ul><li>When a record is created or updated in Airtable, add or update a row in an Excel table stored on OneDrive or SharePoint.</li><li>On a schedule, search Airtable for records, build a CSV, and email it.</li></ul><p>The upside is flexibility: you can transform data, combine sources and trigger on events. The downsides are that you build and maintain the workflow, mapping fields can be fiddly, and these platforms charge by usage, so a large table synced often can cost more than you expect. Check each service’s current pricing page. Appending rows also doesn’t reflect edits or deletions unless you build for those cases too.</p><p>If what you actually want is “send me this view as an Excel file every Monday”, that’s a narrow job, and <a href="https://viewcourier.com/">ViewCourier</a> does it. You connect an Airtable view, choose CSV, XLSX or PDF, set a schedule and a recipient list, and the file is attached to an email each time it runs. The filters, sorting and visible fields of the view carry through, so you change what’s exported by editing the view in Airtable.</p><p>On the free plan you get one weekly or monthly export of up to 1,000 rows. Daily exports are on the paid plans. There is a step-by-step walkthrough in the guide on <a href="https://viewcourier.com/guides/airtable-scheduled-export-to-excel">scheduling an Airtable export to Excel</a>.</p><p>Limits to be aware of: it sends a file, it doesn’t keep an Excel workbook live, and edits you make in Excel don’t go back to Airtable. If you need to analyze the data further, treat the emailed file as the input to your own workbook.</p><ul><li><strong>Need it once:</strong> download the CSV and import it with <strong>From Text/CSV</strong>.</li><li><strong>Need a real </strong><strong>.xlsx once, with no setup:</strong> the browser tool.</li><li><strong>Want to refresh inside Excel yourself:</strong> Power Query.</li><li><strong>Need to push data into other systems or react to events:</strong> Zapier, Make or similar.</li><li><strong>Want a file in your inbox on a schedule, with no code:</strong> a scheduled export.</li></ul><p><strong>Can Airtable export directly to .xlsx?</strong> Not from the grid view’s download menu, based on Airtable’s help center. The documented export is CSV. You can open that in Excel and save it as.xlsx, or use a tool that produces .xlsx directly.</p><p><strong>How do I keep leading zeros and special characters?</strong> Import with <strong>Data &gt; From Text/CSV</strong>, set the encoding to UTF-8, and change the affected columns to Text in the preview or in Power Query before loading. Don’t double-click the file.</p><p><strong>Does the export include hidden fields or filtered-out records?</strong> No. A view export includes what the view shows. To export everything, use a view with no filters and all fields visible.</p><p><strong>Can I schedule an Airtable export to Excel for free?</strong> The manual routes are free, but they aren’t scheduled. Power Query is free and refreshable, but only when Excel is open and you trigger it. ViewCourier’s free plan covers one weekly or monthly emailed export of up to 1,000 rows.</p><p><strong>Is it safe to give a tool my Airtable token?</strong> Use a personal access token with only data.records:read and access to the one base you need. Keep it out of shared files, and revoke it when you no longer need it. With any tool, check whether it processes your data in your browser or on a server before you paste a token in.</p><p><strong>Why do my dates look wrong in Excel?</strong> Excel interprets text dates using your computer’s regional settings, which may not match the format in the CSV. Import the column as Text or set the date format explicitly in Power Query, then convert.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-export-airtable-to-excel-free-including-automatic-weekly-exports"><em>https://viewcourier.hashnode.dev</em></a><em> on October 25, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1c8def3cbb61" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Connect Airtable to Google Sheets (Free, Auto-Updating)]]></title>
            <link>https://medium.com/@viewcourierapp/how-to-connect-airtable-to-google-sheets-free-auto-updating-e5d0b599d90b?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/e5d0b599d90b</guid>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Sun, 25 Oct 2026 01:54:44 GMT</pubDate>
            <atom:updated>2026-10-25T05:08:46.240Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*GrE6DzSE_R_J4hum" /></figure><p>Disclosure: drafted with AI assistance and checked by the ViewCourier team, which builds a tool mentioned below.</p><p>Airtable is a good place to keep data, and Google Sheets is a good place to chart it, share it with people who don’t have Airtable seats, or feed it into formulas. The question is how to get one into the other, and how to keep it current.</p><p>There are five realistic ways to do it, from a one-off download to a live link. This post goes through each one, with a complete free script for the do-it-yourself route, and notes what each approach can’t do.</p><ul><li><strong>CSV download + import:</strong> free, manual, one-time snapshot.</li><li><strong>Google Apps Script + Airtable API:</strong> free, scheduled, full overwrite on each run. You maintain it.</li><li><strong>Airtable automation “Append a new row”:</strong> paid Airtable plans, event-driven, append-only.</li><li><strong>Zapier / Make / Coupler.io:</strong> third-party tools, more flexible, can go two-way, with their own pricing and task limits.</li><li><strong>A live CSV link + </strong><strong>IMPORTDATA:</strong> one formula, refreshed by Google, one-way, read-only.</li></ul><p>Which is right depends on three questions: does it need to update on its own, do you need edits to flow back into Airtable, and are you willing to maintain code?</p><p>If you only need a snapshot, do this and stop.</p><ol><li>Open the Airtable view you want. The export respects the view, so its filters, sorting and visible fields decide what you get.</li><li>Click the view’s name (or the ... menu next to it) and choose <strong>Download CSV</strong>.</li><li>In Google Sheets, open <strong>File &gt; Import &gt; Upload</strong>, drop the file in, and pick whether to create a new sheet, insert a new tab, or replace the current one.</li></ol><p>Two things to know. First, the import is a copy: nothing updates when Airtable changes. Second, linked-record and lookup fields come out as plain text, and attachment fields come out as filenames with URLs, which Airtable only keeps valid for a limited time.</p><p>This is the right choice for a monthly report you build once. For anything you’d repeat weekly, automate it.</p><p>Apps Script is built into Google Sheets, costs nothing, and can call any REST API on a timer. Airtable’s API returns up to 100 records per request and gives you an offset value to fetch the next page. That&#39;s all you need.</p><ol><li>Go to Airtable’s <strong>Builder hub &gt; Personal access tokens</strong> and create a new token.</li><li>Give it the scope data.records:read. Read-only is enough, and it&#39;s safer.</li><li>Under <strong>Access</strong>, add only the base you’re exporting.</li><li>Copy the token. You’ll see it once.</li></ol><p>You’ll also need the base ID (starts with app, visible in the base&#39;s URL or in the API docs for the base) and the table name or table ID (starts with tbl).</p><p>If you’d rather not edit code by hand, ViewCourier has a <a href="https://viewcourier.com/tools/airtable-to-google-sheets">free generator that builds this script for you</a> from your base, table and view names. The version below is the same idea written out in full.</p><p>In your Google Sheet, open <strong>Extensions &gt; Apps Script</strong>, delete the placeholder code, and paste this:</p><pre>const BASE_ID = &#39;appXXXXXXXXXXXXXX&#39;; // from the Airtable base URL const TABLE = &#39;Table 1&#39;; // table name or tblXXXXXXXXXXXXXX id const VIEW = &#39;Grid view&#39;; // view name or viwXXXXXXXXXXXXXX id const SHEET_NAME = &#39;Airtable&#39;; // tab to overwrite function syncAirtable() { const token = PropertiesService.getScriptProperties().getProperty(&#39;AIRTABLE_TOKEN&#39;); if (!token) throw new Error(&#39;Add AIRTABLE_TOKEN in Project Settings &gt; Script Properties&#39;); const records = fetchAllRecords_(token); // Header row = union of field names, in the order first seen const headers = []; const seen = {}; records.forEach(function (r) { Object.keys(r.fields).forEach(function (name) { if (!seen[name]) { seen[name] = true; headers.push(name); } }); }); const rows = records.map(function (r) { return [r.id].concat(headers.map(function (h) { return toCell_(r.fields[h]); })); }); const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheet = ss.getSheetByName(SHEET_NAME) || ss.insertSheet(SHEET_NAME); sheet.clearContents(); const values = [[&#39;Record ID&#39;].concat(headers)].concat(rows); sheet.getRange(1, 1, values.length, values[0].length).setValues(values); } function fetchAllRecords_(token) { const all = []; let offset = null; do { let url = &#39;https://api.airtable.com/v0/&#39; + BASE_ID + &#39;/&#39; + encodeURIComponent(TABLE) + &#39;?pageSize=100&amp;view=&#39; + encodeURIComponent(VIEW); if (offset) url += &#39;&amp;offset=&#39; + encodeURIComponent(offset); const body = fetchJson_(url, token); (body.records || []).forEach(function (r) { all.push(r); }); offset = body.offset || null; if (offset) Utilities.sleep(250); // stay under 5 requests/second } while (offset); return all; } function fetchJson_(url, token) { for (let attempt = 0; attempt &lt; 3; attempt++) { const res = UrlFetchApp.fetch(url, { headers: { Authorization: &#39;Bearer &#39; + token }, muteHttpExceptions: true }); const code = res.getResponseCode(); if (code === 200) return JSON.parse(res.getContentText()); if (code === 429) { Utilities.sleep(30000); continue; } // rate limited: wait and retry throw new Error(&#39;Airtable API &#39; + code + &#39;: &#39; + res.getContentText()); } throw new Error(&#39;Airtable API kept returning 429&#39;); } function toCell_(value) { if (value === undefined || value === null) return &#39;&#39;; if (Array.isArray(value)) return value.map(toText_).join(&#39;, &#39;); if (typeof value === &#39;object&#39;) return toText_(value); if (typeof value === &#39;string&#39; &amp;&amp; value.charAt(0) === &#39;=&#39;) return &quot;&#39;&quot; + value; return value; } function toText_(item) { if (item === undefined || item === null) return &#39;&#39;; if (typeof item !== &#39;object&#39;) return String(item); // Attachments have url, collaborators have name/email, buttons have label return item.url || item.name || item.email || item.label || JSON.stringify(item); }</pre><p>Then store the token outside the code:</p><ol><li>In the Apps Script editor, open <strong>Project Settings</strong> (the gear icon).</li><li>Under <strong>Script Properties</strong>, add a property named AIRTABLE_TOKEN and paste your token as the value.</li></ol><p>Keeping the token in Script Properties means it isn’t in the script text, so you can share the spreadsheet or copy the code into a forum post without leaking access to your base.</p><ul><li><strong>Pagination:</strong> it requests pageSize=100 and keeps calling with the returned offset until Airtable stops sending one.</li><li><strong>Header row:</strong> Airtable leaves empty fields out of each record, so the script builds the header from the union of field names across all records, in the order it first sees them.</li><li><strong>Arrays and objects:</strong> multi-selects, linked records, lookups and attachments arrive as arrays or objects. The script flattens them into comma-separated strings. Attachments become their URLs, collaborators become names.</li><li><strong>Clear and write:</strong> it clears the target tab and writes everything in a single setValues call, which is much faster than writing cell by cell. Because it overwrites the whole tab each run, don&#39;t put your own formulas inside the range it writes. Put them on a separate tab that references the data.</li><li><strong>Rate limits:</strong> Airtable allows 5 requests per second per base. The script pauses 250 ms between pages and, if it does get a 429 response, waits 30 seconds and retries.</li></ul><p>We ran this script’s fetch-and-flatten logic with Node against a test base, using a stubbed Apps Script environment, with a page size of 3 so it had to follow offset across several pages. It collected every record and built the combined header correctly. A real Apps Script run behaves the same way, but you should still run it once by hand to authorize it.</p><ol><li>Select syncAirtable in the function dropdown and click <strong>Run</strong>. Google will ask you to authorize the script (it needs access to the spreadsheet and to make external requests).</li><li>Open <strong>Triggers</strong> (the clock icon), click <strong>Add Trigger</strong>, choose syncAirtable, event source <strong>Time-driven</strong>, and pick an interval, such as every hour or every day.</li></ol><ul><li>Apps Script has a maximum run time per execution and daily quotas on external requests. A few thousand records is no problem; hundreds of thousands will need a different approach.</li><li>The view in VIEW decides which records and fields come back, so you can filter on the Airtable side and keep the script unchanged.</li><li>You own the maintenance. If someone renames a table or the token expires, the trigger will start failing. Apps Script can email you on failures if you set that in the trigger’s notification settings.</li></ul><p>Airtable’s Automations feature includes a Google Sheets action called <strong>Append a new row</strong>. A typical setup is: trigger “When a record is created” (or “when a record matches conditions”), action “Google Sheets: Append a new row”, map your fields to columns.</p><p>It’s well suited to logging events, such as every new form submission becoming a row in a sheet. Per Airtable’s documentation, this integration is available on paid plans.</p><p>What it doesn’t do: it only appends. If a record is edited or deleted in Airtable, the existing row in Sheets is not changed or removed. So the sheet slowly drifts from the truth unless you only care about a log of events. You also can’t backfill existing records without extra steps.</p><p>If you want something that isn’t code and isn’t limited to appending, the third-party tools cover it:</p><ul><li><strong>Zapier and Make</strong> are general automation platforms. Each has Airtable and Google Sheets modules. You can create, update or look up rows, and you can build flows in both directions, so an edit in a sheet can update an Airtable record. Both price by usage (tasks or operations), so a high-volume table can cost more than you expect. Check their current pricing pages.</li><li><strong>Coupler.io</strong> is built around scheduled data imports. You connect Airtable as a source and Sheets as a destination and choose a refresh schedule. It’s closer to the Apps Script approach, but with a UI instead of code.</li></ul><p>If you need a real two-way sync, where changes in either place show up in the other, this is the category to look at. A plain export or a read-only link can’t do it. Be careful with two-way setups: two systems editing the same data will eventually conflict, so decide which one is the source of truth.</p><p>Google Sheets has a function, IMPORTDATA, that loads a CSV from a URL into a sheet. If the CSV is served from a stable link that always reflects the current state of an Airtable view, the sheet stays current without scripts or triggers.</p><p><a href="https://viewcourier.com/">ViewCourier</a> provides that link. You connect an Airtable view, get a CSV URL that always serves the latest data from that view, and put this in cell A1:</p><pre>=IMPORTDATA(&quot;https://your-viewcourier-csv-link&quot;)</pre><p>Google refreshes IMPORTDATA roughly hourly, so this isn&#39;t real-time, and Google doesn&#39;t publish an exact interval. The live CSV link is part of ViewCourier&#39;s paid plans. The <a href="https://viewcourier.com/guides/airtable-to-google-sheets-auto-sync">auto-sync guide</a> walks through the setup.</p><p>If you’d rather have the file than a link, ViewCourier can also email a scheduled CSV (or XLSX or PDF) of a view on a daily, weekly or monthly schedule. That suits people who want a regular report in their inbox rather than a live sheet.</p><p>Like the script, this is one-way: Airtable to Sheets. Anything you type into the imported range will be overwritten or blocked. Build your own calculations on a separate tab that points at the imported data.</p><ul><li><strong>Need it once:</strong> CSV download and import.</li><li><strong>Comfortable with a little code, want it free:</strong> Apps Script.</li><li><strong>Want a log of new records only, and you’re already on a paid Airtable plan:</strong> native automation.</li><li><strong>Need edits to flow both ways or complex logic:</strong> Zapier, Make, or a dedicated sync tool.</li><li><strong>Want a simple one-way live feed with no code:</strong> a live CSV link with IMPORTDATA, or a scheduled emailed export.</li></ul><p><strong>Can I do this without any paid tools?</strong> Yes. Download a CSV for a one-off copy, or use the Apps Script above for a scheduled sync. Both are free. Only the Airtable native automation and the third-party services depend on paid plans.</p><p><strong>How often can the data update?</strong> With Apps Script, you choose the trigger interval, with the practical floor being what Google’s trigger options and quotas allow, and Airtable’s 5 requests/second limit as the main API constraint. With IMPORTDATA, Google decides, and it&#39;s roughly hourly. With Airtable automations, a row is added when the trigger fires.</p><p><strong>Will changes I make in Google Sheets show up in Airtable?</strong> Not with any of the approaches in sections 1, 2, 3 or 5; they’re one-way. For two-way sync you need Zapier, Make, or a dedicated tool, and you should plan for conflict handling.</p><p><strong>Is it safe to give a script my Airtable token?</strong> Use a personal access token with only data.records:read and access to a single base, and keep it in Script Properties rather than in the code. If it ever leaks, you can revoke it from Airtable&#39;s token page without affecting anything else.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-connect-airtable-to-google-sheets-free-auto-updating"><em>https://viewcourier.hashnode.dev</em></a><em> on October 25, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e5d0b599d90b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Download all Airtable attachments: 3 ways]]></title>
            <link>https://medium.com/@viewcourierapp/download-all-airtable-attachments-3-ways-04befa171095?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/04befa171095</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[airtable]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Sat, 24 Oct 2026 00:40:12 GMT</pubDate>
            <atom:updated>2026-10-24T10:07:12.256Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Disclosure: this article was drafted with AI assistance and the code was tested by the ViewCourier team. Originally published on the ViewCourier blog.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*o_ikCIuz-8Rnn-10" /></figure><p>Airtable has no “download all attachments” button. If a base holds a few hundred contracts, photos or invoices and you need them on disk, you have three realistic options: click through the interface, write a script against the API, or use a tool that does the scripting for you. This article covers all three, including a complete Node.js script that I ran before publishing.</p><p>One scope note up front: Airtable attachments live in fields of a table, not in the base as a whole. For a whole base, run the script (or the browser tool) once per table.</p><p>In the interface you can:</p><ul><li>Open a record (the expand icon), hover over an attachment and click the download icon. That is one file per click.</li><li>Export a view as CSV from the view menu (Download CSV).</li></ul><p>The CSV export is where people expect more than they get. An attachment cell in the CSV contains the file name and a URL, not the file. Those URLs are the problem. Airtable’s <a href="https://support.airtable.com/articles/9671148410-airtable-attachment-url-behavior">attachment URL behavior article</a> says download URLs expire for security reasons, and that Airtable will keep them active for at least 2 hours after you receive them. The <a href="https://airtable.com/developers/web/api/field-model">Web API field model</a> says the same for the API: URLs expire 2 hours after the API returns them, and if you want to keep the files you should download them instead of storing the URL.</p><p>So a CSV full of attachment URLs is not a backup of your files. An hour later the links may work; a day later they will not. There is a longer write-up of this in <a href="https://viewcourier.com/guides/airtable-csv-attachment-links-expired">why Airtable attachment links in a CSV export stop working</a>.</p><p>Airtable’s own <a href="https://support.airtable.com/articles/9139007724-attachment-fields-in-airtable">attachment fields article</a> also confirms there is no built-in bulk download, and includes a Scripting extension example for it, which it describes as simplified and likely to have limitations.</p><p>The manual route is fine for ten files. For anything bigger you need the API.</p><p>Everything below works with a personal access token. Create one at <a href="https://airtable.com/create/tokens">airtable.com/create/tokens</a> with the scope data.records:read and add the base you want to export. The script needs nothing else. A read-only token is all it takes; it never writes to your base.</p><p>You need:</p><ul><li>Node 18 or newer (for the built-in fetch). No npm packages.</li><li>Your base ID (starts with app, visible in the URL of the base).</li><li>The table name or ID.</li></ul><p>What the script does:</p><ul><li>Lists records page by page, following Airtable’s offset until there is none. 100 records per page.</li><li>Optionally reads only one view, so the view’s filters apply.</li><li>Looks at every field of every record and treats any array of objects with a url and a filename as attachments. You do not have to name the fields, though you can restrict it with FIELDS.</li><li>Saves each file into attachments/&lt;record id&gt;/. The file name is the attachment ID plus the original name, which keeps two files called scan.pdf in one record apart.</li><li>Cleans file names: characters that are illegal on Windows or act as path separators become _, leading and trailing dots and spaces are removed, Windows reserved names like CON get a prefix, and very long names are cut to 120 characters while keeping the extension.</li><li>Skips files that already exist, so you can re-run it after an interruption. Files are written to a .part file first and renamed when complete, so a half-downloaded file is never mistaken for a finished one.</li><li>Spaces API calls 220 ms apart to stay under Airtable’s limit of 5 requests per second per base, and on HTTP 429 waits 30 seconds, which is what Airtable asks for. It also retries 5xx errors a few times.</li><li>Downloads the files of each page before fetching the next page. That matters because the URLs in a page are only good for about 2 hours. Collecting all URLs first and downloading later would break on a big table.</li></ul><p>Save this as download-attachments.mjs:</p><pre>// download-attachments.mjs // Download every attachment in an Airtable table (or one view) into one folder per record. // Node 18+, no dependencies. // // AIRTABLE_TOKEN=pat... BASE_ID=app... TABLE=&quot;My table&quot; node download-attachments.mjs // // Optional: VIEW=&quot;Grid view&quot; OUT_DIR=./attachments FIELDS=&quot;Photos,Contracts&quot; import { createWriteStream } from &#39;node:fs&#39;; import { mkdir, stat, rename, rm } from &#39;node:fs/promises&#39;; import { Readable } from &#39;node:stream&#39;; import { pipeline } from &#39;node:stream/promises&#39;; import path from &#39;node:path&#39;; const { AIRTABLE_TOKEN, BASE_ID, TABLE, VIEW, OUT_DIR = &#39;./attachments&#39;, FIELDS, // comma-separated field names; default: every attachment field found API_ROOT = &#39;https://api.airtable.com&#39;, // only change this for testing PAGE_SIZE = &#39;100&#39;, } = process.env; if (!AIRTABLE_TOKEN || !BASE_ID || !TABLE) { console.error(&#39;Set AIRTABLE_TOKEN, BASE_ID and TABLE (and optionally VIEW, OUT_DIR, FIELDS).&#39;); process.exit(1); } const only = FIELDS ? new Set(FIELDS.split(&#39;,&#39;).map((s) =&gt; s.trim())) : null; const sleep = (ms) =&gt; new Promise((r) =&gt; setTimeout(r, ms)); // Airtable allows 5 requests per second per base. Space API calls 220 ms apart. let lastCall = 0; async function throttle() { const wait = lastCall + 220 - Date.now(); if (wait &gt; 0) await sleep(wait); lastCall = Date.now(); } // fetch with retry on 429 (Airtable asks you to wait 30 s) and 5xx. async function request(url, options = {}, { api = false } = {}) { for (let attempt = 1; ; attempt++) { if (api) await throttle(); const res = await fetch(url, options); if (res.ok) return res; const retryable = res.status === 429 || res.status &gt;= 500; if (!retryable || attempt &gt;= 5) { const body = await res.text().catch(() =&gt; &#39;&#39;); throw new Error(`HTTP ${res.status} for ${url.split(&#39;?&#39;)[0]} ${body.slice(0, 200)}`); } const delay = res.status === 429 ? 30_000 : 1000 * 2 ** attempt; console.warn(`HTTP ${res.status}, retrying in ${delay / 1000}s`); await res.body?.cancel(); await sleep(delay); } } const RESERVED = /^(con|prn|aux|nul|com[1-9]|lpt[1-9])(\..*)?$/i; function sanitise(name, fallback = &#39;file&#39;) { let s = String(name ?? &#39;&#39;) .normalize(&#39;NFC&#39;) .replace(/[\u0000-\u001f\u007f&lt;&gt;:&quot;/\\|?*]/g, &#39;_&#39;) // illegal on Windows, or a path separator .replace(/^[.\s]+|[.\s]+$/g, &#39;&#39;); // no leading/trailing dots or spaces if (!s) s = fallback; if (RESERVED.test(s)) s = `_${s}`; if (s.length &gt; 120) { const ext = path.extname(s).slice(0, 12); s = s.slice(0, 120 - ext.length) + ext; } return s; } // An attachment is an object with id, url and filename. This also matches // lookup fields that pull in attachments from a linked table. const isAttachment = (x) =&gt; x &amp;&amp; typeof x === &#39;object&#39; &amp;&amp; typeof x.url === &#39;string&#39; &amp;&amp; typeof x.filename === &#39;string&#39;; async function exists(file) { try { return (await stat(file)).size &gt; 0; } catch { return false; } } async function downloadOne(att, dir) { const file = path.join(dir, `${sanitise(att.id)}_${sanitise(att.filename)}`); if (await exists(file)) return &#39;skipped&#39;; await mkdir(dir, { recursive: true }); const res = await request(att.url); const tmp = `${file}.part`; try { await pipeline(Readable.fromWeb(res.body), createWriteStream(tmp)); await rename(tmp, file); } catch (err) { await rm(tmp, { force: true }); throw err; } return &#39;downloaded&#39;; } async function main() { const base = `${API_ROOT}/v0/${BASE_ID}/${encodeURIComponent(TABLE)}`; const headers = { Authorization: `Bearer ${AIRTABLE_TOKEN}` }; const stats = { pages: 0, records: 0, withFiles: 0, downloaded: 0, skipped: 0, failed: 0 }; let offset; do { const qs = new URLSearchParams({ pageSize: PAGE_SIZE }); if (VIEW) qs.set(&#39;view&#39;, VIEW); if (offset) qs.set(&#39;offset&#39;, offset); const res = await request(`${base}?${qs}`, { headers }, { api: true }); const page = await res.json(); stats.pages++; // Download this page right away: the URLs in it expire about two hours after Airtable returns them. for (const record of page.records) { stats.records++; let hasFiles = false; for (const [fieldName, value] of Object.entries(record.fields)) { if (only &amp;&amp; !only.has(fieldName)) continue; if (!Array.isArray(value) || !value.length || !value.every(isAttachment)) continue; hasFiles = true; const dir = path.join(OUT_DIR, record.id); for (const att of value) { try { const result = await downloadOne(att, dir); stats[result]++; } catch (err) { stats.failed++; console.error(`FAILED ${record.id} / ${fieldName} / ${att.filename}: ${err.message}`); } } } if (hasFiles) stats.withFiles++; } offset = page.offset; // absent on the last page console.log(`page ${stats.pages}: ${stats.records} records so far, ${stats.downloaded} files downloaded`); } while (offset); console.log(&#39;done&#39;, JSON.stringify(stats)); if (stats.failed) process.exitCode = 2; } main().catch((err) =&gt; { console.error(err.message); process.exit(1); });</pre><p>Run it:</p><pre>export AIRTABLE_TOKEN=patXXXXXXXXXXXXXX.xxxxxxxx # your token export BASE_ID=appXXXXXXXXXXXXXX export TABLE=&quot;Clients&quot; # table name or tbl... ID # optional: export VIEW=&quot;Grid view&quot; OUT_DIR=./attachments FIELDS=&quot;Photos,Contracts&quot; node download-attachments.mjs</pre><p>It prints one line per page and a summary with the counts of downloaded, skipped and failed files. The exit code is 2 if any file failed, so you can use it in a cron job or CI step.</p><h3>What I actually ran</h3><p>I ran this exact file with Node on a small test base. Two things were checked, and only the first against Airtable itself:</p><ul><li><strong>Against the real Airtable API:</strong> a table of 8 records. With the default page size it read 1 page. With PAGE_SIZE=2 it followed the offset through 4 pages and counted the same 8 records. That test table has no attachment fields, so no file was downloaded from Airtable&#39;s servers.</li><li><strong>Download path, against a local mock server that imitates the API:</strong> 5 records in 3 pages, one record with an empty attachment field, one linked-records field that must be ignored, file names such as a/b:c?.pdf, CON.txt and a 200-character name, one temporary HTTP 500 and one permanent HTTP 404. Result: 11 files downloaded into per-record folders, the 500 retried successfully, the 404 reported as failed with exit code 2, and a second run skipped all 11 existing files.</li></ul><p>That is the honest limit of the test. The code that talks to airtableusercontent.com is a plain fetch of a URL, so I expect it to behave the same on a real attachment, but I have not watched it do so on one.</p><h3>A quick curl and jq version</h3><p>If you only want the list of URLs, for example to feed wget, this does it for the first 100 records:</p><pre>curl -s -H &quot;Authorization: Bearer $AIRTABLE_TOKEN&quot; \ &quot;https://api.airtable.com/v0/$BASE_ID/$TABLE?pageSize=100&quot; | jq -r &#39;.records[] | .id as $rec | .fields[] | select(type == &quot;array&quot;) | .[] | select(type == &quot;object&quot; and has(&quot;url&quot;)) | [$rec, .filename, .url] | @tsv&#39;</pre><p>Each line is the record ID, file name and URL, separated by tabs. For more than 100 records you have to pass the offset from each response into the next request, which is what the script handles for you. Remember the same expiry applies: download the files soon after listing them. I ran this jq filter against the same mock data as above (12 attachment rows from 4 records) and the real table (which has no attachments, so it returns nothing there).</p><p>If you would rather not run code, ViewCourier has a free tool: <a href="https://viewcourier.com/tools/airtable-download-attachments">Download all Airtable attachments</a>. It does what the script does, with a form.</p><ol><li>Paste a personal access token with the scopes data.records:read and schema.bases:read, and add the base to the token.</li><li>Choose the base, the table and, optionally, a view.</li><li>Tick the attachment fields you want.</li><li>Pick a layout: one folder per record (named after the record’s primary field), a flat list with the record name in front of each file name, or a flat list with the original file names.</li><li>Click Scan. The tool reads the records through the API and shows how many files there are, their total size and the largest file.</li><li>Click Download ZIP.</li></ol><p>Some details that matter:</p><ul><li>The page runs in your browser. The token is sent only to api.airtable.com, and the files go straight from Airtable&#39;s file servers to your computer. Nothing goes through ViewCourier&#39;s servers and nothing is stored there.</li><li>The ZIP is built in the browser’s memory. Large jobs are split into parts of up to 500 MB (and 10,000 files), each of which downloads as soon as it is ready. The tool’s page lists a limit of 100,000 files and 20 GB per run.</li><li>Each ZIP contains attachments-manifest.csv, which lists record ID, record name, field, path inside the ZIP, original file name, size and status for every file. That is handy for checking that nothing is missing, or for matching files to records later.</li><li>File names Windows or macOS cannot handle are cleaned, and duplicate names get (2), (3) and so on.</li><li>It fetches fresh links when you scan, so scan and download in one sitting.</li></ul><p>For a whole base, repeat the process per table. Delete the token afterwards if you do not need it any more; you can create a new one in a minute.</p><ul><li>A handful of files: the interface.</li><li>Recurring downloads, a server, a cron job, or files going to your own storage: the script. You control naming, destination and scheduling.</li><li>A one-off bulk download without code, with a manifest: the browser tool.</li></ul><p>Whichever you pick, do it soon after the links are generated, and keep the files themselves. A list of URLs will not outlive the afternoon.</p><p>The files are one half of a backup; the records are the other. <a href="https://viewcourier.com/">ViewCourier</a> can email an Airtable view as a CSV, XLSX or PDF on a schedule, and there is a Free plan. The rest of the free tools are listed on the <a href="https://viewcourier.com/tools">tools page</a>.</p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-download-all-attachments-from-an-airtable-base-3-ways"><em>https://viewcourier.hashnode.dev</em></a><em> on October 24, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=04befa171095" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to export an Airtable base to JSON (3 ways)]]></title>
            <link>https://medium.com/@viewcourierapp/how-to-export-an-airtable-base-to-json-3-ways-ad9d1e50ec6b?source=rss-35d326109a3b------2</link>
            <guid isPermaLink="false">https://medium.com/p/ad9d1e50ec6b</guid>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[airtable]]></category>
            <dc:creator><![CDATA[ViewCourier]]></dc:creator>
            <pubDate>Fri, 23 Oct 2026 08:49:40 GMT</pubDate>
            <atom:updated>2026-10-24T07:02:02.180Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Disclosure: this article was drafted with AI assistance and the code was tested by the ViewCourier team. Originally published on the ViewCourier blog.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*o555-Pfz2mtIRPhn" /></figure><p>Airtable has no “Export base to JSON” button. The UI gives you CSV per view, and that’s it. If you want JSON, for a backup, a migration, a static site, or just to feed another script, you have to go through the API or use a tool that does that for you.</p><p>Here are three ways to do it, from most flexible to least effort. I tested the script and the shell loop below against a real base before writing this.</p><p>All three methods need a personal access token (PAT).</p><ol><li>Open <a href="http://airtable.com/create/tokens">airtable.com/create/tokens</a> and click <strong>Create token</strong>.</li><li>Add the scopes data.records:read and schema.bases:read.</li><li>Under <strong>Access</strong>, pick the base (or bases) you want to export.</li><li>Copy the token. It starts with pat.</li></ol><p>You also need the base ID (starts with app). It&#39;s in the URL when you open the base: airtable.com/appXXXXXXXXXXXXXX/.... Table IDs start with tbl, but table names work in the API too.</p><p>Two limits shape every script: the API returns at most <strong>100 records per page</strong>, and it allows <strong>5 requests per second per base</strong>. Over that, you get HTTP 429 and have to wait about 30 seconds.</p><p>The list-records endpoint is GET https://api.airtable.com/v0/{baseId}/{tableIdOrName}. When a table has more than 100 records, the response includes an offset string. Pass it back as a query parameter to get the next page. When offset is missing, you&#39;re done.</p><p>This script (Node 18+, no dependencies) loops until offset disappears, backs off on 429s, and writes everything to export.json:</p><pre>// export.mjs: dump every record of one Airtable table to JSON import { writeFileSync } from &quot;node:fs&quot;; const { AIRTABLE_TOKEN, BASE_ID, TABLE } = process.env; const url = `https://api.airtable.com/v0/${BASE_ID}/${encodeURIComponent(TABLE)}`; const sleep = (ms) =&gt; new Promise((r) =&gt; setTimeout(r, ms)); const records = []; let offset; do { const qs = new URLSearchParams({ pageSize: &quot;100&quot; }); if (offset) qs.set(&quot;offset&quot;, offset); const res = await fetch(`${url}?${qs}`, { headers: { Authorization: `Bearer ${AIRTABLE_TOKEN}` }, }); if (res.status === 429) { // rate limited: wait, retry the same page await sleep(30_000); continue; } if (!res.ok) throw new Error(`${res.status} ${await res.text()}`); const page = await res.json(); records.push(...page.records); offset = page.offset; // undefined on the last page await sleep(250); // stay under 5 requests/second } while (offset); writeFileSync(&quot;export.json&quot;, JSON.stringify(records, null, 2)); console.log(`Saved ${records.length} records`);</pre><p>Run it like this:</p><pre>AIRTABLE_TOKEN=patXXXX BASE_ID=appXXXX TABLE=Clients node export.mjs</pre><p>Each record looks like this:</p><pre>{ &quot;id&quot;: &quot;rec2rIP4G7xcj21oe&quot;, &quot;createdTime&quot;: &quot;2026-10-21T14:51:28.000Z&quot;, &quot;fields&quot;: { &quot;Name&quot;: &quot;Acme, Inc.&quot;, &quot;Status&quot;: &quot;Active&quot;, &quot;Monthly fee&quot;: 1200 } }</pre><p>Useful query parameters: view=Grid%20view limits the export to what a view shows (including its filters and sort order), fields[]=Name&amp;fields[]=Email returns only those columns, and filterByFormula filters server-side. For a whole base, call the script once per table.</p><h3>Get the schema too</h3><p>A records dump doesn’t tell you field types, which matters if you ever re-import the data. The Meta API returns them:</p><pre>curl -s -H &quot;Authorization: Bearer $AIRTABLE_TOKEN&quot; \ &quot;https://api.airtable.com/v0/meta/bases/$BASE_ID/tables&quot;</pre><p>The response lists every table with its ID, fields (name, ID, type, options) and views. That’s also how you get a list of table names to loop over. If you’d rather not write code for this part, there’s a browser-based <a href="https://viewcourier.com/tools/airtable-schema-export">Airtable schema export tool</a>.</p><p>If you have a shell and jq, you don&#39;t need Node. The pagination loop is short:</p><pre>#!/usr/bin/env bash # export.sh: needs AIRTABLE_TOKEN, BASE_ID, TABLE set -euo pipefail URL=&quot;https://api.airtable.com/v0/$BASE_ID/$TABLE&quot; OFFSET=&quot;&quot; while :; do RESP=$(curl -sS -H &quot;Authorization: Bearer $AIRTABLE_TOKEN&quot; \ &quot;$URL?pageSize=100${OFFSET:+&amp;offset=$OFFSET}&quot;) echo &quot;$RESP&quot; | jq -c &#39;.records[]&#39; # one record per line OFFSET=$(echo &quot;$RESP&quot; | jq -r &#39;.offset // empty&#39;) # empty on the last page [ -z &quot;$OFFSET&quot; ] &amp;&amp; break sleep 0.25 # stay under 5 req/s done | jq -s &#39;.&#39; &gt; export.json</pre><p>The trick is ${OFFSET:+&amp;offset=$OFFSET}: the &amp;offset= part is only added when OFFSET is non-empty, so the first request has no offset. The loop prints one JSON record per line, and jq -s slurps them into a single array at the end.</p><p>For a single page (up to 100 records), you can skip the loop. This one flattens each record so the fields sit next to the ID:</p><pre>curl -s -H &quot;Authorization: Bearer $AIRTABLE_TOKEN&quot; \ &quot;https://api.airtable.com/v0/$BASE_ID/Clients?pageSize=100&quot; \ | jq &#39;[.records[] | {id} + .fields]&#39;</pre><p>A flat array like that is usually easier to feed into other tools than the nested {id, createdTime, fields} shape.</p><p>If you don’t want to touch a terminal, use the <a href="https://viewcourier.com/tools/airtable-to-json">Airtable to JSON tool</a>. It runs entirely in your browser: you paste a personal access token, pick a base and table, and it handles the pagination and rate limit for you. Your token is used for requests from your browser to Airtable and never goes to a server.</p><p>You can choose between:</p><ul><li><strong>Full JSON</strong>, the same {id, createdTime, fields} structure the API returns.</li><li><strong>Flat JSON</strong>, one plain object per record, with the field values at the top level.</li></ul><p>Then copy the result or download it as a file. It’s the quickest option for a one-off export of a single table. For anything you need to repeat or automate, use Method 1 or 2.</p><p>The JSON you get is the raw API view of your data, not a mirror of the grid. These are the usual surprises:</p><ul><li><strong>Linked records are record IDs.</strong> A “Clients” link in an “Orders” table comes back as [&quot;rec123...&quot;, &quot;rec456...&quot;], not names. To resolve them, export the linked table too and join on id. Or add a lookup field in Airtable that pulls the name through.</li><li><strong>Lookups and rollups are arrays</strong>, even when there’s only one value. A lookup of a single number is [42], not 42. Multi-select and collaborator fields are arrays too.</li><li><strong>Empty fields are omitted.</strong> If a cell is empty (or a checkbox is unchecked), the key isn’t in fields at all. Don&#39;t assume every record has every key. In Node, use record.fields.Email ?? &quot;&quot;. In jq, use .Email // &quot;&quot;. Build your column list from the schema, not from the first record.</li><li><strong>Attachment URLs expire.</strong> Each attachment has a url that stops working after a few hours. If your JSON is a backup, download the files right away, or you&#39;ll end up with dead links. This is the same reason <a href="https://viewcourier.com/guides/airtable-csv-attachment-links-expired">exported CSV attachment links stop working</a>.</li><li><strong>Views are only honored if you ask.</strong> Without view=..., you get every record in the table in the table&#39;s default order, not what a filtered view shows.</li><li><strong>Formula and computed fields can fail per record.</strong> They may come back as an error object such as {&quot;error&quot;: &quot;#ERROR!&quot;} instead of a value. Check for that before parsing.</li><li>A script you’ll run again, or a backup in CI: <strong>Method 1</strong>.</li><li>Quick, scriptable, nothing to install on most Linux and macOS machines (apart from jq): <strong>Method 2</strong>.</li><li>A one-time dump and you don’t want to write code: <strong>Method 3</strong>.</li></ul><p>JSON is the right format when another program reads the data. If what you need is the opposite, a recurring CSV or Excel file of one view landing in someone’s inbox without anyone running scripts, that’s what ViewCourier does, and there’s a walkthrough of the options in <a href="https://viewcourier.com/guides/email-airtable-view-on-a-schedule">how to email an Airtable view on a schedule</a>.</p><p><em>ViewCourier is not affiliated with Airtable. Airtable is a trademark of its owner.</em></p><p><em>Originally published at </em><a href="https://viewcourier.hashnode.dev/how-to-export-an-airtable-base-to-json-3-ways"><em>https://viewcourier.hashnode.dev</em></a><em> on October 23, 2026.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad9d1e50ec6b" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>