Sync Google Sheets to Airtable using Integromat

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ธ.ค. 2024

ความคิดเห็น • 45

  • @dalankerr
    @dalankerr 2 ปีที่แล้ว +2

    Thank you so much for posting this, it is EXACTLY what I needed in combination with your 2-way sync video :D

  • @danceindia
    @danceindia 4 ปีที่แล้ว +3

    Hi, Thank you for the nice tutorial. I am wondering how do you delete if rows are deleted

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  4 ปีที่แล้ว

      In this case you would have to use a different approach. Instead of identifying fields in Airtable based on their name (stored in first key column), you would have to add fixed row numbers in Airtable. You could create a fix number for a row using Auto-number field type. This way each row would have a fixed row number similar to row number in Google Sheets. Integromat trigger from Google Sheets returns row numbers of changed fields - which you could use to identify which rows in Airtable have to be update or cleared ( content of all cells apart from row Auto-number would be cleared). Let me know if this answers your question?

  • @ChandrikaShenoy-m2v
    @ChandrikaShenoy-m2v ปีที่แล้ว +1

    Thank you for this. I tried this approach and it works for one cell change at a time. Is there a way to tweak the Make scenario for bulk updates? So say I have two columns of which one has fixed values and for the second column, I copy paste 10 rows at a time. I want the corresponding 10 rows in airtable to be filled as well. Currently using the approach you have mentioned above, I am able to update one change or one row at a time. What tweak would be needed for bulk updation ?

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  ปีที่แล้ว

      If you copy paste data in bulk it will also trigger update for each row affected.
      You could alternatively use schedule approach - run a function to update data to Airable every X hours, but it will always run for each row. Not sure if that is what you were aiming at?

  • @mahmoudbedeir4141
    @mahmoudbedeir4141 3 ปีที่แล้ว +1

    Hello, thanks for this informative tutorial! I've one question, how can I get 2 or more records in airtable from one row in google sheets.

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  3 ปีที่แล้ว

      You would put multiples Create Airtable Record modules in a chain so that based on one row of data from Excel you generate for example 3 records in Airtable (eg. in Order Table, Customer Table and Delivery Table)

  • @digital-Marketing-barcelona
    @digital-Marketing-barcelona 2 ปีที่แล้ว

    Great thanks for sharing this, it is just what I was looking for :)

  • @DS-ig1bf
    @DS-ig1bf 2 ปีที่แล้ว +1

    Very helpful thank you. I would love to see the next level to this, creating Airtable Tables synced to multiple sheets in one GoogleSheet. My Airtable Base has mutliple tables in order to create different data types, Person, City, Organization, each have their own table. Would I need to create different webhooks for each sheet?

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  2 ปีที่แล้ว

      You can! Once you add the Integromat/Make webhook extension to your Google Sheet Document it monitors updates on all sheets. The data arriving in Airtable will have "Sheet1" or "Sheet2" and etc. This way you could filter the data to different Airtable tables.

  • @staceywhite5826
    @staceywhite5826 ปีที่แล้ว +1

    Are there any updates to this, struggling to get this to work. If I paste new rows in my Google Sheets, it only copies the first row. I noticed AirTable has different options now, since this video. Thank you for any updated info!! 🙂

  • @shareami9045
    @shareami9045 4 ปีที่แล้ว +2

    Hello and thanks for this tutorial ! I've done every steps, it seems to work alright in integromat, but the changes don't appear in my Airtable, would you know where the problem comes from ? Thank you very much for your answer

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  4 ปีที่แล้ว

      What is the output visible in the bubbles on Airtable module during execution in Integromat? If there is data coming in to Airtble incorrectly it would throw and error. Maybe mapping of fields should be checked?

  • @agoogleuser6937
    @agoogleuser6937 2 ปีที่แล้ว +1

    What if we use the airtable ids as primary key (vlookup/watch field)?

  • @TheAjw26
    @TheAjw26 4 ปีที่แล้ว +2

    Thanks for the great tutorial, but I cannot turn on my integromat for automatic scheduling. There is an issue with the bundle validation which ends the process. I have structured my data in the same way and have set up the scenario in the same way but I am now sure how to solve this error. Please can you suggest what might be the issue? Thanks in advance 🙏🏽

  • @vinzdegar
    @vinzdegar 3 ปีที่แล้ว +1

    Thanks!

  • @miguel_pinto_0
    @miguel_pinto_0 6 หลายเดือนก่อน +1

    And If I want to delete a row how can I do that, what will be the filter that i could put

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  6 หลายเดือนก่อน

      That is bit trickier - you would have to put an action "Delete" and have a fliter reacting to it and executing delete in Airtable.

  • @MrAjayen
    @MrAjayen 3 ปีที่แล้ว +1

    Hello Business Automated. I really enjoy watching your videos on Integromat gives me a broad knowledge about the application . I am wondering if there is a way to make Integromat watch multiple google sheets at once and update the data from a specific cell or column?
    I am really curious to know 😀

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  3 ปีที่แล้ว +1

      There are 2 approaches to that depending what frequency of update sync you need. If this needs to be instant than the "Watch Rows" and "Watch Changes" triggers are the way to go. You could specify to react to changes in only specific row /column and make Integromat ignore any other changes. In this case for each watch trigger (for each Sheet) , you would need a separate scenario
      Another approach would be to use "Search Rows" or "Get Range Values" in a scheduled scenario ( that runs example every 5 or 10 min) to check for a specific value. In this case you could have multiple Search Rows modules in single scenario if you need to check for example 5 sheets in the same time.

    • @MrAjayen
      @MrAjayen 3 ปีที่แล้ว +1

      Thanks a lot for your quick response. Let’s say I am want to get a specific data from 5 different google sheets document and post and creat a reporting message in skype or slack or any messenger application. Here I do not want to create 5 individual scenarios as it is not effective when it comes to number of operations. So I will need a single scenario to watch all the 5 Google Sheets and this will
      Be scheduled to work twice a day I.e morning and evening. Please advise :)

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  3 ปีที่แล้ว

      In this case second option would work best would be to start with "Array iterator" containing IDs of the 5 different sheets as start and "Search Rows" as second module and the rest the way as you want to set it up.

  • @MicaelaMotta
    @MicaelaMotta 3 ปีที่แล้ว +1

    Can you make a tutorial using uosert record as the last option instead of the router?

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  3 ปีที่แล้ว

      Yes, at the time video was made there was no upset option. It could certainly work instead of router if else scenario.

  • @AlessandroEren
    @AlessandroEren 2 ปีที่แล้ว +2

    lEGEND!

  • @geraespinosar
    @geraespinosar 3 ปีที่แล้ว +1

    can you make a tutorial for sync sharepoint items to airtable, for users with microsoft solutions already T_T ?

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  3 ปีที่แล้ว

      Hi! Great idea. I will need to check my my office 365 account and see what I can do. Do you want to sync files or do you want sync data from Excel?

    • @geraespinosar
      @geraespinosar 3 ปีที่แล้ว

      @@BusinessAutomatedTutorials Sync data definitely please, because me and my team already use power apps at the work.
      Cheers

  • @thejorgemarques
    @thejorgemarques 4 ปีที่แล้ว

    Hi great tutorial, I actually changed the Google Sheet to Airtable also, just different table, but I get same error all the time: Cannot initialize the scenario because of the reason 'Flow is empty and contains no configured module'
    Scenario initialization failed with an error. Thank you very much.

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  4 ปีที่แล้ว

      Have you added the Integromat plug in in Google Sheets? The error is showing up inside of Integromat? Have set Google Sheets as the first module with little lightning icon on it?

  • @Sammiebuilds
    @Sammiebuilds ปีที่แล้ว +1

    ⚠HELP: I get an error whenever I update the entire row on my Google Sheet at once. Is there a fix for this?
    "Error
    [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text."
    Thank you for putting this video here for free, you just gained a new follower.

    • @BusinessAutomatedTutorials
      @BusinessAutomatedTutorials  ปีที่แล้ว

      This:
      "Error
      [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text."
      Means you have an error with your Airtable module and the formula you have inserted there is not valid.
      Best way to test is create that formula in Airtable first, check if it returns a correct value - if yes add in the make module.

  • @mkvhoqnuncdotfwqumbm845
    @mkvhoqnuncdotfwqumbm845 2 ปีที่แล้ว +1

    text

  • @comp2477
    @comp2477 ปีที่แล้ว

    great. thank you