Open source syncing to sheets || Tags

Hi everybody!

I’ve started using Airtable to create an inventory for work, I’ve started working with creating multiple tables:

Employees | Devices | SecondDevices | Other Devices | Monitors | Group1 | Group2 | Budget

I need to sync all devices (Devices, SecondDevices, OtherDevices, Monitors) that have a tag within budget.
The case being that budget has 2 types, internal and external budget.

Goal 1: All external budgets should be exported or synced to Google Spreadsheet automatically.
Goal 2: Entries in one table should be duplicated when added a tag.

Question 1: What is the best (free) way to sync Airtable to spreadsheets automatically.
(register new entry’s and update old entry’s)

I tried Zapier & Automate.io and it is not possible with the free licensing.

Question 2: Can I create tags in Airtable?
Question 3: Is it possible to add an entry and that it get’s autofilled in another table by adding a tag or through another way?

A lot of questions, I know.
If there is something that’s unclear (which I suspect!). Let me know and I’ll adjust the question.

Kind regards!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.