Pulling content from Gmail to a table

[Paul_Danyliuk]

You can put these inputs in the table and try parsing them either with regular expressions (more powerful but requires regex knowledge), or with basic “split into lines, filter where the string starts with “p1” etc” formulas.

Some inspiration:

Typeform -> Zapier -> Coda, the alternative way

Here’s an alternative way to import Typeform questions and answers into Coda without having to map every form field to a column in Zapier. Instead, the whole form is inserted as one big value. Then all parsing is done on Coda side. IDK, may be useful in some cases.

Extract data from complex JSON with regular expressions

This is more of a lesson in efficiency. Inspired by this post: Task: there’s a JSON with extremely nested structure. Need to extract all values for the key "text" anywhere in the JSON tree. The first instinct would be to parse the JSON into objects and try to traverse the tree somehow. However, in this very scenario, "text" entries don’t all appear at the same level of nesting. So traversing and collecting them would require composing some complicated logic in Coda. Efficient solution: treat…