Clay Icon

Bulk Adding Columns in Spreadsheet: Is There a Faster Way?

·
·

is there a way for me to add all of the columns from at the same time vs. 1 by 1?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, thanks for reaching out! The only way to handle this is by using a _write to table_function and adding a list to map the values. Unfortunately, there’s no other way to add multiple columns all at once, which also helps prevent reaching the table limits too quickly. 😊 What exactly were you trying to achieve here? Let me know if you need any help! 👍

  • Avatar of David L.
    David L.
    ·
    ·

    this was what I was trying to do - have a couple of questions in here for you as well: https://www.loom.com/share/6e070d69ea864a2b9a7763f7b2b4fe37

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Oh, no sorry for all that manual work. And yes, the logic behind SalesNav is excellent! As for the other part, we do have an integration that can send all the data directly to Google Sheets. However, when it comes to writing to a table, here’s how it works: For Write to table you have to ways: list objects or without list objects, you can have a main table inside Clay. Then, you can use a Lookup to check if there’s any matching data in your next search. This will allow you to efficiently compare and organize your data across searches. Let me know if you need further help with setting it up! 👍

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi David L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: