With lembot, you can choose between extracting all the CSV or only a set of columns.
When choosing "All columns", lembot will import in your GSheet the lemlist CSV report as is. No more no less.
The end result is the same as if you had done the export and import manually.
Why should I select columns?
This has 2 major advantages:
When you select columns, the export stay consistent over time. So does your formula 😉
There is two ways to choose your output: select columns or write columns.
While creating or editing a bot, click "Select columns".
Lembot will automatically detect your campaign CSV header and displays them in a table.
Once detected you can select which columns to extract, then click Continue to confirm your selection and finalize your bot.
This is a bit more advanced, yet very powerful feature. It lets you shape exactly your final output in your GSheet.
While creating or editing a bot, click "Write columns".
Start typing and see the column preview update automatically.
Note that you can edit your extract mode (all columns, select columns, or write columns) and your columns selection at any moment.
Click "Run export" to only export the selected variables to your Google Sheets.
As you can see on the right, the sheet has only 4 columns as requested: